SORT WITH OUT SQZ=(



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

SORT WITH OUT SQZ=(

Postby SAT_SYSPROG » Thu Mar 05, 2009 4:32 pm

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
SAT_SYSPROG
 
Posts: 2
Joined: Thu Mar 05, 2009 4:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SORT WITH OUT SQZ=(

Postby SAT_SYSPROG » Thu Mar 05, 2009 5:50 pm

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
SAT_SYSPROG
 
Posts: 2
Joined: Thu Mar 05, 2009 4:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SORT WITH OUT SQZ=(

Postby Alissa Margulies » Thu Mar 05, 2009 8:36 pm

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.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: SORT WITH OUT SQZ=(

Postby Alissa Margulies » Sat Apr 05, 2014 4:50 am

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.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times

Re: SORT WITH OUT SQZ=(

Postby BillyBoyo » Sat Apr 05, 2014 5:18 am

Sorry. Looks like I clicked View unread posts instead of View new posts.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post