Sorting 119 type 70 records



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Sorting 119 type 70 records

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

//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....
tcpipman
 
Posts: 18
Joined: Tue Sep 22, 2015 2:03 pm
Has thanked: 4 times
Been thanked: 0 time

Re: Sorting 119 type 70 records

Postby 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.
tcpipman
 
Posts: 18
Joined: Tue Sep 22, 2015 2:03 pm
Has thanked: 4 times
Been thanked: 0 time

Re: Sorting 119 type 70 records

Postby 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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Sorting 119 type 70 records

Postby 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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post