|
View previous topic :: View next topic
|
| Author |
Message |
CICS fan
New User
Joined: 03 Apr 2008
Posts: 82
Location: United States
|
|
|
|
Hello i asked this in dfsort forum and later realised we have syncsort running in our system.
the problem is:
i have an input file of a particular layout:
thru syncsort i want to add a trailer record whose layout will be:
hardcoded '2' --record type
date --- this will be run date(system date) minus one day in ccyymmdd format
record count--integer 9--total no of records excluding trailer
please suggest. |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| What version of Syncsort you are running on? |
|
| Back to top |
|
|
CICS fan
New User
Joined: 03 Apr 2008
Posts: 82
Location: United States
|
|
|
|
Anuj,
I tried this:
SORT FIELDS=COPY
INCLUDE COND=(1,1,CH,EQ,C'1')
OUTFIL FILES=01,OUTREC=(1,178),REMOVECC,
TRAILER1=('2',2:&DATE-1,COUNT=(M11,LENGTH=9))
and its working fine, but i want the trailer date as CCYYMMDD and its coming as MM/DD/YY |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
CICS fan,
Here are the SyncSort for z/OS 1.3 control statements that will produce the requested output:
| Code: |
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(1,1,CH,EQ,C'1')
OUTFIL FILES=01,OUTREC=(1,178),REMOVECC,
TRAILER1=('2',2:&DATENS=(4MD)-1,COUNT=(M11,LENGTH=9))
/* |
|
|
| Back to top |
|
|
CICS fan
New User
Joined: 03 Apr 2008
Posts: 82
Location: United States
|
|
|
|
Alissa,
Thanks a ton! It works and my headcahe is over! Thanks again! |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| You're very welcome, and thanks for letting us know. |
|
| Back to top |
|
|
|
|
