Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

syncsort trailer problem

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Mon Oct 26, 2009 1:42 pm    Post subject: syncsort trailer problem
Reply with quote

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
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Mon Oct 26, 2009 4:22 pm    Post subject:
Reply with quote

What version of Syncsort you are running on?
Back to top
View user's profile Send private message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Mon Oct 26, 2009 4:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Oct 26, 2009 9:21 pm    Post subject:
Reply with quote

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
View user's profile Send private message
CICS fan

New User


Joined: 03 Apr 2008
Posts: 82
Location: United States

PostPosted: Tue Oct 27, 2009 2:03 pm    Post subject:
Reply with quote

Alissa,

Thanks a ton! It works and my headcahe is over! Thanks again!
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Oct 27, 2009 10:31 pm    Post subject:
Reply with quote

You're very welcome, and thanks for letting us know.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Validating file with multiple header/... mohitsaini DFSORT/ICETOOL 6 Thu Apr 13, 2017 1:53 am
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us