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 Strings with double quotes having pro... raja Arumugam IBM Tools 0 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
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am


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