Hi Friends,
I want to use the Make Subrecord Stage,
I have my flow like, Seqfilestage->Makesubrecordstg->seqfilestg
I have four inp cols, one is key col and the rest are char field.
In Make sub rec stg, i have given non key cols as vector column for subrecord and the "parent" as the subrecord output column.
i dont find anyother option to use ....when i execute, it says parent is not the value field.
Please let me know how to use this stage to get the subrecord.
Thanks,
Senthil P
Make SubRecord Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks Ray,
My input data set has:
col datatype
Key integer (10)
ColA varchar(10)
ColB varchar(10)
ColC varchar(10)
Make SubRec Stage:
Under stage properties, i have given non key cols as vector column for subrecord and the "parent" as the subrecord output column.
In Input Stage,
col datatype
Key integer (10)
ColA varchar(10)
ColB varchar(10)
ColC varchar(10)
In output Stage,
Key integer (10)
parent varchar(10)
While executing it gives the error like, " Tgt_dataset: Operator initialization: A link between two operators should be named with a .v; insert a copy operator to save a persistent copy of the data"
I dint get this error info. Kindly let me know about this.
Thanks,
SenthilP
My input data set has:
col datatype
Key integer (10)
ColA varchar(10)
ColB varchar(10)
ColC varchar(10)
Make SubRec Stage:
Under stage properties, i have given non key cols as vector column for subrecord and the "parent" as the subrecord output column.
In Input Stage,
col datatype
Key integer (10)
ColA varchar(10)
ColB varchar(10)
ColC varchar(10)
In output Stage,
Key integer (10)
parent varchar(10)
While executing it gives the error like, " Tgt_dataset: Operator initialization: A link between two operators should be named with a .v; insert a copy operator to save a persistent copy of the data"
I dint get this error info. Kindly let me know about this.
Thanks,
SenthilP
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Rather than the SQL data types I need to see the actual record schema, to be sure that you have defined the subrecord correctly. For example, how do you propose to shoehorn three VarChar(10) strings into one VarChar(10) parent?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.