Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
sas
Charter Member
Posts: 13 Joined: Sun Mar 05, 2006 12:37 am
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Charter Member
Posts: 13 Joined: Sun Mar 05, 2006 12:37 am
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Charter Member
Posts: 13 Joined: Sun Mar 05, 2006 12:37 am
Post
by sas » Thu Aug 02, 2007 12:25 am
Not working
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Thu Aug 02, 2007 1:24 am
Ray caught my misteak <sic>; I posted the wrong function
sas
Charter Member
Posts: 13 Joined: Sun Mar 05, 2006 12:37 am
Post
by sas » Thu Aug 02, 2007 2:41 am
Cool .. It worked !!! Thanks.