Hi,
I'm testing the PX version of datastage.
Parallel Job:
RowGenerator Stage-->Sequential File Stage
there are 5 defined columns
all my columns are nullable expect for the third colum
in the seq file stage "Nullable" is set to Yes for the 3rd column only
I get the following warning:
Sequential_File_4: When checking operator: When validating export schema: At field "Amount": Exporting nullable field without null handling properties
the job does generate a text file however i notice that i am getting an empty string (is this the same as null) for some values for the last column in the generated record
i generated 10 random records (rows)
Sequential File Stage Exporting nullable field - Warning
Moderators: chulett, rschirm, roy
Welcome Aboard!
Set the "Null Field Value" property in the sequential file for the 3rd field to "".
You will find this property in the "Format" tab of the sequential File stage.
P.S. Try doing a search before you create new posts, most of the answers are already answered!
Set the "Null Field Value" property in the sequential file for the 3rd field to "".
You will find this property in the "Format" tab of the sequential File stage.
P.S. Try doing a search before you create new posts, most of the answers are already answered!
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.