DSXchange

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)

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!

Thanks for Welcome narasimha!

You're absolutely right.. I should have done a search. wow lot of answers

I got it work by setting the Null Field Value to " " (11 spaces)

the column was fixed-width at 11 spaces and this worked - no warnings
no erros

also the column is of type decimal length 9 scale 2