How to include a blank line



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

How to include a blank line

Postby Shruthi » Thu Feb 03, 2011 3:46 pm

Hi,

Need some help...

My input file would be like:

In US Number of customers processed : 100
In US Number of customers rejected : 10
In US Number of customers approved : 90
In DK Number of customers processed : 100
In DK Number of customers rejected : 10
In DK Number of customers approved : 90
In EU Number of customers processed : 100
In EU Number of customers rejected : 10
In EU Number of customers approved : 90

I need to format the file to include a blank line and contents in output file should be like:

In US Number of customers processed : 100
In US Number of customers rejected : 10
In US Number of customers approved : 90

In DK Number of customers processed : 100
In DK Number of customers rejected : 10
In DK Number of customers approved : 90

In EU Number of customers processed : 100
In EU Number of customers rejected : 10
In EU Number of customers approved : 90

can i do this using any sort techniques... please help.
Shruthi
 
Posts: 4
Joined: Tue Jan 18, 2011 5:21 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to include a blank line

Postby skolusu » Thu Feb 03, 2011 10:26 pm

shruthi,

Use the following DFSORT JCL. I assumed that your first 5 characters designate the key break.

//STEP0100 EXEC PGM=SORT                         
//SYSOUT   DD SYSOUT=*                           
//SORTIN   DD *                                   
IN US NUMBER OF CUSTOMERS PROCESSED : 100         
IN US NUMBER OF CUSTOMERS REJECTED  : 10         
IN US NUMBER OF CUSTOMERS APPROVED  : 90         
IN DK NUMBER OF CUSTOMERS PROCESSED : 100         
IN DK NUMBER OF CUSTOMERS REJECTED  : 10         
IN DK NUMBER OF CUSTOMERS APPROVED  : 90         
IN EU NUMBER OF CUSTOMERS PROCESSED : 100         
IN EU NUMBER OF CUSTOMERS REJECTED  : 10         
IN EU NUMBER OF CUSTOMERS APPROVED  : 90         
//SORTOUT  DD SYSOUT=*                           
//SYSIN    DD *                                   
  SORT FIELDS=COPY                               
  OUTFIL REMOVECC,SECTIONS=(1,5,SKIP=L)           
//*
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times

Re: How to include a blank line

Postby Shruthi » Fri Feb 04, 2011 9:19 am

Thanks Kolusu... Your assumption was right...the sort worked perfectly...thanks once again
Shruthi
 
Posts: 4
Joined: Tue Jan 18, 2011 5:21 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post