moving records from seq file to netezza table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
attu
Participant
Posts: 225
Joined: Sat Oct 23, 2004 8:45 pm
Location: Texas

moving records from seq file to netezza table

Post by attu »

Hi,
Can someone help me out with the follwing error message

When checking operator: When validating export schema: At field "CHR_SRC_ID": Exporting nullable field without null handling properties
Thanks[/b]
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Attu,

this is a very common error message and has been discussed several times in this forum, try using an exact search for the string "Exporting nullable field without null handling properties" and you will get 25 hits.

This happens when DS has a nullable field going to an output which either isn't nullable or doesn't accept nulls, so you have to modify the column definition to give it an action to take on nulls.

right-mouse-click on the column name, use "edit row" and add a null handler.
Post Reply