DSXchange

HI

I have child table foreign key as Nullable.
When i tried to insert null ,Datastage is converting to Zero and try to Insert.

Zero is not value in Parent table ...


Can you please clarify why datastage is converting from null to Zero

thks

Hi sainath,

Are you sure your column is set to nullable throughout the complete job-flow?

Are you sure the value you want to insert is NULL? Watch out for warnings telling you that an implicit conversion from a string to a numeric value failed and a default value was used.

Just for the record: If the column was a foreign key, I would assume that NULL was no more valid than 0, unless the foreign key constraint was not physically implemented.