Lotue LEI Direct Transfer error message, SQL0407N
Posted on 2003-12-09
Hi, I'm getting this error message, SQL0407N Assignment of a NULL value to a NOT NULL column "*N" is not allowed. SQLSTATE=23502, Connector 'DataWarehouse', Method -Insert- (-407)
when i'm trying to send 9 fields from a Notes database to a AS400 DB2 database. All the fields are Text on the Notes side and all are Alpha on the DB2 side.
I searched Google and found this explanation, it looks like it comes down to data types incompatible but how can that be if I'm moving Text to Alphas?
SQL0408N A value is not compatible with the data type of its assignment target. Target name is "<name>".
Explanation: The data type of the value to be assigned to the column, parameter, SQL variable, or transition variable by the SQL statement is incompatible with the declared data type of the assignment target. Both must be:
Dates or character
Times or character
Timestamps or character
The same distinct types
Reference types where the target type of the value is a subtype of the target type of the column.
The same user-defined structured types. Or, the static type of the value must be a subtype of the static type (declared type) of the target.
The statement cannot be processed.
User Response: Examine the statement and possibly the target table or view to determine the target data type. Ensure the variable, expression, or literal value assigned has the proper data type for the assignment target.