logo  
Google
 

DB2 SQL-Error: -593

SQLState: 42831

Short Description: NOT NULL MUST BE SPECIFIED FOR ROWID OR DISTINCT TYPE COLUMN

ROWID columns and distinct type columns for which the source type is a ROWID do not support null values. When a ROWID column (or distinct type for which the source type is a ROWID) is defined on a CREATE TABLE, ALTER TABLE, or DECLARE TABLE statement, the NOT NULL clause must be specified for the column. System action: The statement cannot be executed. Programmer response: Change the statement to specify NOT NULL for ROWID column column-name.

 <-  BACK TO INDEX