logo  
Google
 

DB2 SQL-Error: -408

SQLState: 42821

Short Description: THE VALUE IS NOT COMPATIBLE WITH THE DATA TYPE OF ITS TARGET TARGET NAME IS C E SQL I CHAR DECIMAL

The data type of the value to be assigned to the column, parameter, host variable or transition variable by the SQL statement is incompatible with the declared data type of the assignment target. Both must be: v Numeric v Character v Graphic v Dates or character v Times or character v Timestamps or character v Row IDs v The same distinct types However, dates, times, or timestamps cannot be assigned to a character column that has a field procedure. Also note that character and graphic data types are compatible when using Unicode. This SQLCODE is issued for any statement that fails required assignment rule checking. System action: The statement cannot be executed. Programmer response: Examine the current definition

 <-  BACK TO INDEX