Hi,
I need to read a sequential file in it simple format i.e. comma delimited, double qouted format. Nulls are represented as double quoted empty strings i.e. "".
Thanks for your help !
very simple:null represented as double quoted empty string
Moderators: chulett, rschirm, roy
very simple:null represented as double quoted empty string
What is the problem you are having? Does PX not recognize the "" as a NULL?
did u specify the QUOTE property on the sequential file stage as 'double'. This tells it that the column will have leading and trailing double quotes.
Try this, write a simple test job with source sequential stage to read this input, and define the quote property as double. Use a transformer to directly map these columns to another sequential file stage. But on the target sequential stage, set the QUOTE property to 'none'. When u run the job, if u see the contents of the target file, u will see that it set that column with "" as null.
for example, if your source was reading a record
"a","b","","c","d"
the output file would have had this as
a,b,,c,d
hope this helps
Try this, write a simple test job with source sequential stage to read this input, and define the quote property as double. Use a transformer to directly map these columns to another sequential file stage. But on the target sequential stage, set the QUOTE property to 'none'. When u run the job, if u see the contents of the target file, u will see that it set that column with "" as null.
for example, if your source was reading a record
"a","b","","c","d"
the output file would have had this as
a,b,,c,d
hope this helps