find no of detailed records

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
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

find no of detailed records

Post by dsdev_123 »

hello

i have a source coming from dataset i need to produce a fixedwidth sequential file which has header and detialed section. i need to capture no of detailed records in one of the columns of header section. i was trying using aggrrgator stage but wasnt able to do.any help would be appreciated

Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Write to two seperate files, one header record and X detail records, then cat them together 'after job'.
-craig

"You can never have too many knives" -- Logan Nine Fingers
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

Re: find no of detailed records

Post by dsdev_123 »

actually i need to count the no of detailed records in the detailed section and and need to use that value in one column of the header section
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right, fine - as you write out the detail, send another link to the Aggregator to get your count, then write that as the header file.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply