IBM Mainframe Forum

by **tcpipman** » Tue Feb 16, 2016 2:28 am

I am trying to do a sort where I pull out only the 119 type 70 records (FTP Server) from my SMF datasets. I created the following SORT JCL but for some reason I am still getting all the records.

Select all

//COPY     EXEC  PGM=SORT                                              
   OPTION  COPY,VLSHRT,TRUNC=RC0,SPANINC=RC4      
//SYSOUT     DD  SYSOUT=*                                              
//SORTIN     DD  DISP=SHR,BUFNO=20,                                    
//           DSN=MYMVS.SMF.D16042                           
//SORTOUT    DD  DISP=(NEW,CATLG,DELETE),&ODCB,&OCLS,&OSPC,DSN=&ODSN   
//SYSIN      DD  *                                                     
  SORT FIELDS=COPY                                                     
   INCLUDE COND=(6,1,BI,EQ,119,&,23,2,BI,EQ,70)                        
//*                                                                    
 

Anyone see what I am doing wrong....

by **tcpipman** » Tue Feb 16, 2016 3:22 am

I figured it out .. the above was an edited version .. I actually had some comments right after my sysin that was causing it to skip my control statements.

by **BillyBoyo** » Tue Feb 16, 2016 4:50 am

No, it is the second line you have shown. When the JCL is being interpreted, any non-JCL line (//, /*, //*) that is not part of DD * or DD DATA gets //SYSIN DD * generated. That second line becomes your SORT Control Cards for the step.

by **NicC** » Tue Feb 16, 2016 2:46 pm

Please use the code tags when posting code and data. I have coded it for you. I was also tempted to move it to the DFSort part of the forum as it was a DFSort problem. However, the problem was caused by your bad JCL so I have left it in the JCL part of the forum.

IBM Mainframe Forum

Sorting 119 type 70 records

Sorting 119 type 70 records

Re: Sorting 119 type 70 records

Re: Sorting 119 type 70 records

Re: Sorting 119 type 70 records