Low Value Handling

sas · Post by **sas** » Wed Aug 01, 2007 10:19 pm

I am processing MF (EBCDIC) data. There are some CHAR columns having X'00' value (low value) at MF. We are doing NDM and processing through DS job. I want to intialize with "" if column encounters this low value.
(1) How to initialize such columns with "" in Sequential Reader while reading the data.
(2) If there is no way of doing this in Sequential Reader. How can we put ""in column derivation in transformer if column has X'00' .

ArndW · Post by **ArndW** » Wed Aug 01, 2007 10:54 pm

You can set the attribute of columns (right-mouse click, then 'edit row') to explicitly set the default value of fields that are not interpreted correctly on input, as would happen with values of \000

sas · Post by **sas** » Wed Aug 01, 2007 11:05 pm

I already did that. I had set TTTTT in default for a CHAR(5) column. It's not working.

ArndW · Post by **ArndW** » Wed Aug 01, 2007 11:19 pm

I see. You can always put a query such as

Code: Select all

IF CHAR(In.Column[1,1])=000 THEN 'TTTTT' ELSE In.Column

I was looking for a way to do it as part of the read instead of as part of the processing.

sas · Post by **sas** » Thu Aug 02, 2007 12:25 am

Not working

ArndW · Post by **ArndW** » Thu Aug 02, 2007 12:45 am

sas - please try to output the value of char(In.Column[1,1]) into a peek stage.. what is the value?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 02, 2007 1:00 am

I think Arnd means Seq() rather than Char(). Is Seq() available in parallel jobs?

ArndW · Post by **ArndW** » Thu Aug 02, 2007 1:24 am

Ray caught my misteak <sic>; I posted the wrong function

sas · Post by **sas** » Thu Aug 02, 2007 2:41 am

Cool .. It worked !!! Thanks.