Page 1 of 1

Sorting 119 type 70 records

PostPosted: Tue Feb 16, 2016 2:28 am
by tcpipman
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.

//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....

Re: Sorting 119 type 70 records

PostPosted: Tue Feb 16, 2016 3:22 am
by tcpipman
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.

Re: Sorting 119 type 70 records

PostPosted: Tue Feb 16, 2016 4:50 am
by BillyBoyo
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.

Re: Sorting 119 type 70 records

PostPosted: Tue Feb 16, 2016 2:46 pm
by NicC
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.