When a table is created, each column is defined as allowing NULL values or not allowing NULL values. How do you change this once the table is created? Attempting to use ALTER TABLE gives the following error:
Could not execute statement.
Cannot enforce the NOT NULL constraint. Column b has NULL data.
SQLCODE=-1000063, ODBC 3 State="HY000"
Line 5, column 1
- SAP IQ 16.1
- SAP IQ 16.0
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.