Page 1 of 1

SORT WITH OUT SQZ=(

PostPosted: Thu Mar 05, 2009 4:32 pm
by SAT_SYSPROG
My requirement is
ABCDEFGHJ    XYZ=    1 
ABCD             XYZ=    4
ABCD             XYZ=    4
ABCDEFGH     XYZ=    2
ABCD             XYZ= 1006
ABCD%%         XYZ=10000
ABCD1212121 XYZ=   50


to
ABCDEFGHJ    XYZ=1  ie . to Left  JUSTIFY '5' collums  after XYZ=
ABCD             XYZ=4
ABCD             XYZ=4
ABCDEFGH     XYZ=2
ABCD             XYZ=1006
ABCD%%         XYZ=10000
ABCD1212121 XYZ=50


On test LPAR the following works and i get the output it want, OUTREC BUILD=(1,16,17,21,SQZ=(SHIFT=LEFT))

//EXCLUDE  EXEC PGM=SYNCTOOL                                     
//TOOLMSG  DD  SYSOUT=*                                         
//DFSMSG   DD  SYSOUT=*                                         
//INDD     DD  DISP=SHR,DSN=TEST.SORT5   
//OUTDD    DD  DISP=OLD,DSN=TEST.SORT6   
//SRT1CNTL DD  *                                               
   OPTION COPY                                                 
   OUTREC BUILD=(1,16,17,21,SQZ=(SHIFT=LEFT))                   
/*                                                             
//SYSPRINT DD  SYSOUT=*                                         
//TOOLIN   DD  *                                               
 COPY FROM(INDD) TO(OUTDD) USING(SRT1)                         
/*                                                             


But on production the same job gives Syntax error :

SRT1CNTL :                                                                     
   OPTION COPY                                                         
   OUTREC BUILD=(1,16,17,21,SQZ=(SHIFT=LEFT))                                 
                            *                                                 
WER428I  CALLER-PROVIDED IDENTIFIER IS "0001"                                 
WER268A  OUTREC STATEMENT  : SYNTAX ERROR                                     
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE       


It looks like SQZ and JFY wont be working , Hope so some APARs may be missing .

Can anyone help me to get sort the above without SQZ or JFY ?

Code'd some more

Re: SORT WITH OUT SQZ=(

PostPosted: Thu Mar 05, 2009 5:50 pm
by SAT_SYSPROG
Hello,

The following helps me to get what i want - LEFT JUSTIFY Columns between 17 and 21 with OUT SQZ=SHIFT=LEFT.

Is this efficent coding ? I dont know , please advice if I am wrong. I am a admin. Generating a SYSIN card with 3 Million records.

//SRT1CNTL DD  *                         
   OPTION COPY                           
   OUTREC IFTHEN=(WHEN=(17,4,CH,EQ,C' '),
                 BUILD=(1,16,21,1)),     
          IFTHEN=(WHEN=(17,3,CH,EQ,C' '),
                BUILD=(1,16,20,2)),       
          IFTHEN=(WHEN=(17,2,CH,EQ,C' '),
                BUILD=(1,16,19,3)),       
          IFTHEN=(WHEN=(17,1,CH,EQ,C' '),
                BUILD=(1,16,18,4))       
/*                                       
//SYSPRINT DD  SYSOUT=*                   
//TOOLIN   DD  *                         
 COPY FROM(INDD) TO(OUTDD) USING(SRT1)   
/*


Code'd

Re: SORT WITH OUT SQZ=(

PostPosted: Thu Mar 05, 2009 8:36 pm
by Alissa Margulies
Hello SAT_SYSPROG and welcome to the Forum,

Support for SQZ and JFY were included in SyncSort for z/OS 1.3. I can only assume that your test LPAR has this release installed, but you are running an earlier release of SyncSort in production.

Re: SORT WITH OUT SQZ=(

PostPosted: Sat Apr 05, 2014 4:50 am
by Alissa Margulies
BillyBoyo,

Why are you responding to a post from 5 years ago? I am almost certain that his Syncsort release has been upgraded and he has already addressed his issue since then.

Re: SORT WITH OUT SQZ=(

PostPosted: Sat Apr 05, 2014 5:18 am
by BillyBoyo
Sorry. Looks like I clicked View unread posts instead of View new posts.