DSXchange

Ray,
But how do I get it in to the job. Those records with NULL values are getting dropped in the sequential file stage itself and Iam not able to get it to the next stage. Suggest me a way to get them in.

As Rasi/Siva said, I even included the Null field value to diff characters but in vain. Any thoughts...

Guys, Thx for your ideas. I have a Nothing fields like two delimiters coming side by side with nothing between them 12|32|43 32||23 Second row in the example has the scenario Iam talking about. When I read such a row using PX sequential file, it gets dropped in reading itself. It doesn't come even t...

How do I read a Delimited sequiential file (having Null values in a couple fields ) with out dropping any of the records in PX. Sample input file format 12|32|43 32||23 Here FIeld2/Row2 is a null. When std PX Sequential file stg is used to read this, second record is getting dropped. Any ideas are a...

All, I have a custom operator being used in my job. Iam getting an error "Contents of phantom output file=> RT_SC524/OshExecuter.sh[16]: 65112 Segmentation fault". Soon after this it coredumps. Do anyone has any idea, what it is?? Does it have to do anything with the custom operator Iam us...

Iam doing a left outer join and have a transformer following that. I have some Null handling, other checks and derivations in the Transformer but no constraints. It appears that the Transformer is dropping certain records where I have not matching records from the right link (These values should be ...

Iam getting an error as 'The required "-table" argument is missing' when Iam trying to read data from a DB2 UDB table. Iam using user defined SQL option to read data from DB2. I even tried with the partitioned table option, but did't help me to get rid of this error. Any help is appreciate...