Doubt in Sort

sivasaras · Post by **sivasaras** » Wed Jun 23, 2010 1:20 pm

Hi,

I have an input file with fields a,b,c and i want the output file to be like C,B,A.

How we can do by using Sort?

Regards,
Siva

Anuj Dhawan · Post by **Anuj Dhawan** » Wed Jun 23, 2010 1:54 pm

Well, it can be done - but it would be good if you show us some practical example of what you want? And also which sort-product do yo use?

sivasaras · Post by **sivasaras** » Wed Jun 23, 2010 2:05 pm

input file

NAME COMPANY UNIT

these are the input fields and now i want the ouput like

UNIT COMPANY NAME

how it can be done through SORT?

Regards,
Siva

Frank Yaeger · Post by **Frank Yaeger** » Wed Jun 23, 2010 10:42 pm

Assuming that the fields are blank delimited and a maximum of 8 bytes each, you can use a DFSORT job like the following to do what you asked for:

Code: Select all

//S1 EXEC PGM=SORT                                           
//SYSOUT DD SYSOUT=*                                         
//SORTIN DD DSN=...  input file                                                
//SORTOUT DD DSN=...  output file                                        
//SYSIN DD *                                                 
  OPTION COPY                                                
  INREC IFTHEN=&#40;WHEN=INIT,                                   
    PARSE=&#40;%01=&#40;ENDBEFR=BLANKS,FIXLEN=8&#41;,                    
               %02=&#40;ENDBEFR=BLANKS,FIXLEN=8&#41;,                
               %03=&#40;FIXLEN=8&#41;&#41;,                              
    BUILD=&#40;%03,X,%02,X,%01&#41;&#41;,                                
  IFTHEN=&#40;WHEN=INIT,BUILD=&#40;1,26,SQZ=&#40;SHIFT=LEFT,MID=C' '&#41;&#41;&#41;  
/*

sivasaras · Post by **sivasaras** » Thu Jun 24, 2010 10:50 am

Hi,

Thanks for the information

.

Regards,
Siva

mainframegurukul.com

Doubt in Sort

Doubt in Sort

Hi,

Hi

FREE TUTORIALS