Page 1 of 1
Low Value Handling
Posted: Wed Aug 01, 2007 10:19 pm
by sas
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' .
Posted: Wed Aug 01, 2007 10:54 pm
by ArndW
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
Posted: Wed Aug 01, 2007 11:05 pm
by sas
I already did that. I had set TTTTT in default for a CHAR(5) column. It's not working.
Posted: Wed Aug 01, 2007 11:19 pm
by ArndW
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.
Posted: Thu Aug 02, 2007 12:25 am
by sas
Not working
Posted: Thu Aug 02, 2007 12:45 am
by ArndW
sas - please try to output the value of char(In.Column[1,1]) into a peek stage.. what is the value?
Posted: Thu Aug 02, 2007 1:00 am
by ray.wurlod
I think Arnd means Seq() rather than Char(). Is Seq() available in parallel jobs?
Posted: Thu Aug 02, 2007 1:24 am
by ArndW
Ray caught my misteak <sic>; I posted the wrong function
Posted: Thu Aug 02, 2007 2:41 am
by sas
Cool .. It worked !!! Thanks.
