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
Datastage insert 0 in null fields
Moderators: chulett, rschirm, roy
Re: Datastage insert 0 in null fields
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.
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.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon