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
allavivek
Premium Member
Posts: 211 Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek » Thu Jul 22, 2010 10:46 pm
Hi All,
Iam using compare stage and for output i enabled RCP and defined 3 cols..
diff(tinyint)
first(unknown)
second(unknown)
Iam getting proper output but problem is iam getting like below format..
Code: Select all
diff first second
-1 (1,aaa,bbb) (3,aaa,bbb)
Iam getting subrecords in braces..Is this correct format or do i need to change any options...
Thank you
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Jul 22, 2010 11:09 pm
This is the correct format. The braces are added by the data browser; they are not actually part of the data, but are indicated by the metadata (record schema) in which subrecord is indicated.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
allavivek
Premium Member
Posts: 211 Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek » Thu Jul 22, 2010 11:11 pm
ray.wurlod wrote: This is the correct format. The braces are added by the data browser; they are not actually part of the data, but are indicated by the metadata (record schema) in which subrecord is indicated. ...
Thank you ray...
allavivek
Premium Member
Posts: 211 Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek » Thu Jul 22, 2010 11:21 pm
But Ray is it possible to copy data from this format to other target...
when iam trying to copy data from dataset to seq file...its giving following error..
input first is not value field....
Thanks...
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Jul 22, 2010 11:56 pm
I guess you need a Promote Subrecord stage in there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
allavivek
Premium Member
Posts: 211 Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek » Fri Jul 23, 2010 10:22 am
ray.wurlod wrote: I guess you need a Promote Subrecord stage in there. ...
Hi ,
I was trying to use promote subrecord stage but in properties iam able to specify only one parent column...but iam two parent columns...
Any ideas...
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Jul 23, 2010 3:57 pm
Two Promote Subrecord stages, then.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
allavivek
Premium Member
Posts: 211 Joined: Sat May 01, 2010 5:07 pm
Post
by allavivek » Fri Jul 23, 2010 3:59 pm
ray.wurlod wrote: Two Promote Subrecord stages, then. ...
So then what format should be the output columns defined for my output data....
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Jul 23, 2010 4:02 pm
Enable RCP and let DataStage decide that, then inspect the output and see how you want to label things.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.