hi,
I couldn't tell how the -440 comes from. but this looks troubling
"The insert has values only for the Not Null coulmns. None of the other fields are populated. "
You probably still need to provide the 'NULL' for those NULLable columns. I will write an INSERT stmt like:
INSERT INTO
DIS_EVENT (
DIS_EVENT_ID BIGINT NOT NULL,
DIS_ID BIGINT NOT NULL,
EVENT_SEQ SMALLINT,
FIELD_NAME VARCHAR(40),
OLD_VALUE VARCHAR(100),
NEW_VALUE VARCHAR(100),
CREATED_SOURCE_TYPE SMALLINT NOT NULL,
CREATED_SOURCE VARCHAR(25),
CREATED_DTTM TIMESTAMP NOT NULL,
DIS_DETAIL_ID BIGINT
)
VALUES( 1, 1, NULL, NULL, NULL, NULL, 1, NULL, current timestamp, NULL);
Bascially, you still need to put 'NULL's in the slot instead of omitting them.
BTW, I assume that you are using DB2/LUW?