SORT OUTREC - Sort card for multiple members in SORTIN

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
charan_Hyd
Member
Posts: 3
Joined: Tue Sep 15, 2009 5:11 pm
Location: Hyderabad

SORT OUTREC - Sort card for multiple members in SORTIN

Post by charan_Hyd » Tue Sep 22, 2009 7:11 pm

I have a pds and inside the pds i have 20 members.

In each member i have some set of records.

I need to get 3 characters from the input record if the starting letter is M.

I need to get these characters from all pds members.

from one member means i can give the below jcl

Code: Select all

//FIXBCBAD EXEC PGM=SORT                                  
//SYSPRINT DD SYSOUT=*                                    
//SYSOUT   DD  SYSOUT=*                                   
//SORTIN   DD  DSN=C000214.TEST.PDS(MEm1),DISP=SHR              
//SORTOUT  DD  DSN=C000214.TEST.PS4,DISP=SHR              
//SYSIN    DD  *                                          
   INCLUDE COND=(1,1,CH,EQ,C'M')                          
   SORT FIELDS=COPY                                       
   OUTREC FIELDS=(2:3,2)                                  
//*                                                       
if i need to implement the above sort card in all pds members
what i need to give


Thanks,
Charan Sedimbi

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Tue Sep 22, 2009 8:17 pm

Just concatenate the members. Here's an example with DFSORT:

Code: Select all

//FIXBCBAD EXEC PGM=SORT
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=C000214.TEST.PDS(MEm1),DISP=SHR
//       DD DSN=C000214.TEST.PDS(MEm2),DISP=SHR
//       DD DSN=C000214.TEST.PDS(MEm3),DISP=SHR
...
//SORTOUT DD DSN=C000214.TEST.PS4,DISP=SHR
//SYSIN DD *
  INCLUDE COND=(1,1,CH,EQ,C'M')
  SORT FIELDS=COPY
  OUTREC FIELDS=(2:3,2)
//*

Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others