Page 1 of 1

syncsort jfy option

PostPosted: Sun Oct 25, 2009 5:20 pm
by RRCHN
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"

Re: syncsort jfy option

PostPosted: Mon Oct 26, 2009 3:18 am
by dick scherrer
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.

Re: syncsort jfy option

PostPosted: Mon Oct 26, 2009 1:37 pm
by RRCHN
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

Re: syncsort jfy option

PostPosted: Mon Oct 26, 2009 1:40 pm
by RRCHN
product version - syncsort for z/os 1.3.2

Re: syncsort jfy option

PostPosted: Mon Oct 26, 2009 2:12 pm
by RRCHN
Found the mistake and fixed it. Thanks.

Re: syncsort jfy option

PostPosted: Tue Oct 27, 2009 12:05 am
by dick scherrer
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. . .