Adding trailer with multiple counts



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Adding trailer with multiple counts

Postby baglasumit21 » Tue Apr 16, 2013 12:34 pm

I have a file with data as below

1020130202PUS
1020130202PUS
1020130202BUS
1020130202PUS
1020130202PUS
1020130202BUS
1020130202PUS
1020130202BUS

I need to add header and trailer which I was able to find on the fourm but in trailer I need multiple count as below

Trailer 0000008 0000003 0000005

where first number is total record count, second is record count with "P" in 11th position and third record count is "B" in 11th Position. Please help me to achieve it
baglasumit21
 
Posts: 2
Joined: Tue Apr 16, 2013 12:28 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Adding trailer with multiple counts

 

Re: Adding trailer with multiple counts

Postby BillyBoyo » Tue Apr 16, 2013 1:50 pm

Can you show the code you have, please, so that we know what to make suggestions on?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: Adding trailer with multiple counts

Postby baglasumit21 » Tue Apr 16, 2013 4:55 pm

Hi Mod..

with help of few posts on the forum.. i was able to achieve what I required.

Thanks for the reply
baglasumit21
 
Posts: 2
Joined: Tue Apr 16, 2013 12:28 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Adding trailer with multiple counts

Postby BillyBoyo » Tue Apr 16, 2013 6:02 pm

Thanks for letting us know.

Perhaps you can post your code, so that it can help others with a similar requirement in the future.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post