syncsort jfy option



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

syncsort jfy option

Postby RRCHN » Sun Oct 25, 2009 5:20 pm

I need to left justify the fields and need to include leading and trailing ' " ' . I tried to achieve the same using JFY,(SHIFT=LEFT,LEAD=C'"',TRAIL=C'""). But it doesnt seems to recognise the "LEAD" option. can someone help me with the jfy --> shift=left syntax for the same?

Sample Input File:
00001bbTEST01bbbvar02
00002bbbTEST0bbbVar03

Expected output:
0001"TEST01""Var02"
0002"TEST0""Var03"
RRCHN
 
Posts: 4
Joined: Sun Oct 25, 2009 4:59 pm
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort jfy option

Postby dick scherrer » Mon Oct 26, 2009 3:18 am

Hello and welcome to the forum,

But it doesnt seems to recognise the "LEAD" option.
What does this mean?

Using the "Code" tag, post all of the sort control information and all of the informational output generated by the execution. Make sure the product release and all messages (including the messag ids) are posted.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: syncsort jfy option

Postby RRCHN » Mon Oct 26, 2009 1:37 pm

Please find the sysout log :

SYSIN :
SORT FIELDS=COPY
OUTREC FIELDS=(1,5,
6,8,JFY=(SHIFT=LEFT,LEAD='"',TRAIL=C'"'),
*
14,8,JFY=(SHIFT=LEFT,LEAD='"',TRAIL=C'"')),
VLTRIM=C' '
WER268A OUTREC STATEMENT : SYNTAX ERROR
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
RRCHN
 
Posts: 4
Joined: Sun Oct 25, 2009 4:59 pm
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort jfy option

Postby RRCHN » Mon Oct 26, 2009 1:40 pm

product version - syncsort for z/os 1.3.2
RRCHN
 
Posts: 4
Joined: Sun Oct 25, 2009 4:59 pm
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort jfy option

Postby RRCHN » Mon Oct 26, 2009 2:12 pm

Found the mistake and fixed it. Thanks.
RRCHN
 
Posts: 4
Joined: Sun Oct 25, 2009 4:59 pm
Has thanked: 0 time
Been thanked: 0 time

Re: syncsort jfy option

Postby dick scherrer » Tue Oct 27, 2009 12:05 am

Good to hear it is working - thanks for letting us know :)

If you post what you changed to fix the error, it will probably help someone with a similar problem later. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post