| View previous topic :: View next topic |
| Author |
Message |
AshuSharma
Beginner
Joined: 11 Oct 2006
Posts: 6
Topics: 1
|
 Posted: Fri Dec 15, 2006 9:34 am Post subject: SORT: COUNT=(EDIT |
 |
|
Hi,
When I use the following command I get Syncsort error WER268A.
| Code: | | OUTFIL TRAILER1=('RECORDS SENT|',14:COUNT=(EDIT=(TTTTTTTTT))) |
Any idea what is going wrong.
Thanks
Diba. |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Dec 15, 2006 12:38 pm Post subject: |
|
|
AshuSharma,
Try this
| Code: |
OUTFIL TRAILER1=('RECORDS SENT|',14:COUNT=(M11,LENGTH=9))
|
If you still get an error then you have an older version of syncsort which does not support the formatting of the count field. However the new syncsort z/os 1.2 version supports the formatting. Here is an alternative way of getting the desired results.
| Code: |
SORT FIELDS=COPY
OUTREC FIELDS=(C'1',30:X)
OUTFIL NODETAIL,REMOVECC,
TRAILER1=('RECORDS SENT|',14:TOT=(1,1,ZD,M11,LENGTH=9))
|
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
AshuSharma
Beginner
Joined: 11 Oct 2006
Posts: 6
Topics: 1
|
| Posted: Mon Dec 18, 2006 1:31 am Post subject: |
|
|
Hi kolusu,
I got the same error with - | Code: | | OUTFIL TRAILER1=('RECORDS SENT|',COUNT=(M11,LENGTH=9)) |
Following command is working but I was looking for better formatting of the trailer - | Code: | | OUTFIL TRAILER1=('RECORDS SENT|',COUNT) |
Thanks,
Diba. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Mon Dec 18, 2006 6:36 am Post subject: |
|
|
AshuSharma,
Did you try the alternate method I suggested in my prior post?
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
DWalker
Beginner
Joined: 19 Dec 2006
Posts: 1
Topics: 0
|
| Posted: Wed Dec 20, 2006 12:53 am Post subject: |
|
|
Kolusu,
I used Ashu's id to post the querry since my id was not working.
I didn't use the TOT method because I felt it would be inefficient compared to count. I finally delivered the output with "OUTFIL TRAILER1=('RECORDS SENT|',COUNT)" and told the recipient team that they will need to take care of the leading space.
Thanks,
Diba. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
