Help needed for this...



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

Help needed for this...

Postby sprint84 » Sat Sep 26, 2009 11:08 am

Hi,

I having a file like this.
***************************** Top of Data ******************************
BP/MUFYI01/0409MUFYI012009040AMUFYI012009040B
BP/MUFYI02/0409MUFYI022009040AMUFYI022009040B
BP/MUFYI03/0409MUFYI032009040AMUFYI032009040B
BP/MUFYI04/0409MUFYI042009040AMUFYI042009040B
BP/MUFYI05/0409MUFYI052009040AMUFYI052009040B
BP/MUFYI06/0409MUFYI062009040AMUFYI062009040B
BP/MUFYI07/0409MUFYI072009040AMUFYI072009040B
BP/MUFYI08/0409MUFYI082009040AMUFYI082009040B
BP/MU/01PV/0408MU1PV040800000AMU1PV04080000B
**************************** Bottom of Data *************************

this file is FixedBlock (FB) and LRECL is 80..

and i need to break these records and write it in a another flat file.. that file also should have same LRECL and RECF as like input file.. and my output should like this


----+----1----+----2----+----3----+----4----+---
***************************** Top of Data ******
BP/MUFYI01/0409MUFYI012009040A
BP/MUFYI01/0409MUFYI012009040B
BP/MUFYI02/0409MUFYI022009040A
BP/MUFYI02/0409MUFYI022009040B
BP/MUFYI03/0409MUFYI032009040A
BP/MUFYI03/0409MUFYI032009040B
BP/MUFYI04/0409MUFYI042009040A
BP/MUFYI04/0409MUFYI042009040B
BP/MUFYI05/0409MUFYI052009040A
BP/MUFYI05/0409MUFYI052009040B
BP/MUFYI06/0409MUFYI062009040A
BP/MUFYI06/0409MUFYI062009040B
BP/MUFYI07/0409MUFYI072009040A
BP/MUFYI07/0409MUFYI072009040B
BP/MUFYI08/0409MUFYI082009040A
BP/MUFYI08/0409MUFYI082009040B
BP/MU/01PV/0408MU1PV040800000A
BP/MU/01PV/0408MU1PV040800000B
**************************** Bottom of Data ****
can any one help to create JCL for this using SORT or ICETOOL... Thanks in advance :)
sprint84
 
Posts: 1
Joined: Sat Sep 26, 2009 10:57 am
Has thanked: 0 time
Been thanked: 0 time

Re: Help needed for this...

 

Re: Help needed for this...

Postby dick scherrer » Sun Sep 27, 2009 3:34 am

Hello,

You (or someone) has posted this multiple times - which is completely inconsiderate (and won't be tolerated).

This is now locked.

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post