JCL to add or remove a line in PDS member



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: JCL to add or remove a line in PDS member

Postby dhana venkatesh » Mon Dec 19, 2016 8:57 pm

Just got one example in google. Will this comes under DFSORT? Will the below satisfy my requirement, ie, remove a line in a member ? . Also want to know the meaning of the strings which is used inside OMIT COND=(34,2,CH,EQ,C'AB'), what is (34,2,CH,EQ,C'AB') ?

//SETP001  EXEC PGM=SORT                                        
//SYSPRINT DD SYSOUT=*                                          
//SYSOUT   DD SYSOUT=*                                          
//SYSUDUMP DD SYSOUT=*                                          
//REPORT1  DD SYSOUT=*                                          
//SORTIN   DD DISP=SHR,DSN=USERID.ABC.INPFILE,
//SORTOUT  DD DSN=USERID.ABC.OUTFILE,
//      DISP=(,CATLG),                                          
//      SPACE=(TRK,(30,10),RLSE),                                
//      UNIT=SYSDA,                                              
//      DCB=(RECFM=FB,LRECL=80,BLKSIZE=0,DSORG=PS)              
//SORTWK01 DD  UNIT=DISK,SPACE=(CYL,(20,5),RLSE)                
//SORTWK02 DD  UNIT=DISK,SPACE=(CYL,(20,5),RLSE)    
//SORTWK03 DD  UNIT=DISK,SPACE=(CYL,(20,5),RLSE)    
//SYSIN    DD *                                      
SORT FIELDS=COPY                                        
OMIT COND=((34,2,CH,EQ,C'AB'),AND,(74,1,CH,EQ,C' '))
/*                                                  
//*


Coded, BTW
dhana venkatesh
 
Posts: 30
Joined: Thu Mar 06, 2014 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Re: JCL to add or remove a line in PDS member

 

Re: JCL to add or remove a line in PDS member

Postby Robert Sample » Mon Dec 19, 2016 9:08 pm

Just got one example in google.
This is insanity. The example may -- or may not -- apply to your site. You need to find examples ON YOUR SITE!
what is (34,2,CH,EQ,C'AB') ?
This is clearly explained in the sort manual for your version of sort. The code is omitting records that have AB in columns 34 and 35 of the input (unless, of course, the input data set is variable length).
Robert Sample
Global moderator
 
Posts: 3344
Joined: Sat Dec 19, 2009 8:32 pm
Location: East Dubuque, Illinois
Has thanked: 1 time
Been thanked: 219 times

Re: JCL to add or remove a line in PDS member

Postby Akatsukami » Mon Dec 19, 2016 9:09 pm

Have you not been told that the messages will allow us to distinguish between sort products? Messages in the SYSOUT spool data set that begin with ICE indicate DFSORT; messages beginning with WER indicate Syncsort (which, IIRC, is now called DMX).

I begin to come around to Mr. Prins' way of thinking.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1049
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: JCL to add or remove a line in PDS member

Postby NicC » Tue Dec 20, 2016 4:22 am

The reason we are being so picky is because although these different products do the same thing the control cards used are not necessarily the same and, even within the same product, may vary depending on whether your data is fixed length or variable length.

As Robert points out, anything on the internet is not necessarily going to work at your place. Each shop has its own standards and naming conventions and you will have to adhere to those.

Do read up in the manual about these control cards that you have found so that you can understand what they do.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2676
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 102 times

Re: JCL to add or remove a line in PDS member

Postby dhana venkatesh » Tue Dec 20, 2016 12:28 pm

Thanks Robert and Nic for your suggestion.
dhana venkatesh
 
Posts: 30
Joined: Thu Mar 06, 2014 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post