View Single Post
  #9 (permalink)  
Old 10-15-07, 14:22
nidm nidm is offline
Registered User
 
Join Date: May 2003
Posts: 113
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?
Reply With Quote