Hi
I am getting this warning.
Assignment of a NULL value to a NOT NULL column "TBSPACEID=3, TABLEID=9, COLNO=94" is not allowed. SQLSTATE=23502
Please respond with useful information.
Thanks
SReddy
Assignment of a NULL value to a NOT NULL column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
If you use a Transformer to map a NULLABLE column to a NOT NULL column and then use the NULLTOVALUE function to choose a default value when a null value is found it should remove the warning messages.
It you are completely sure your NULLABLE fields hold no NULL values and never will hold a NULL value you can demote the warning message to an information message by using a message handler that runs the demotion for just those jobs that are identified as being safe. This can be risky because unhandled NULLs can result in the entire row being dropped or a job abort.
It you are completely sure your NULLABLE fields hold no NULL values and never will hold a NULL value you can demote the warning message to an information message by using a message handler that runs the demotion for just those jobs that are identified as being safe. This can be risky because unhandled NULLs can result in the entire row being dropped or a job abort.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: