adding new sub-columns with default value to group column

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

Post Reply
Teckamal
Participant
Posts: 3
Joined: Sun Mar 14, 2010 10:08 am
Location: IN

adding new sub-columns with default value to group column

Post by Teckamal »

Hi

Is there any way of adding sub-columns to the group column with default value and store it as Mainframe file? or dataset? I am trying to read the Mainframe file which is having additional fields in the layout and funnel with the previous rejected dataset which should have the same columns as that of source.

Problem here is, new fields added are read as character with level number 2 in CFF stage, 50 occurence is now changed to 100 occurence. I am clueless on making the dataset to incorporate new fields to existing group column. please share your ideas on achieving this.

thanks
TK
there is a way to discover things
Post Reply