Page 1 of 1

need Header in this format yyyymmddhhmm,im using SYNCSORT

Posted: Wed Apr 02, 2014 10:17 pm
by sandeepforever007
Hi,
My jcl (using syncsort) sorts some records fetched from the db. I need to add header and trailer to it.
Header should contain datestamp and should be like this
0,YYYYMMDDHHMM

Trailer
Should have the number of records fetched.
How can I achieve this
Pls help
Thanks in advance

Posted: Sun Apr 06, 2014 4:53 am
by DikDude
This is Sandeep
I've raised an issue in the forum yesterday regarding the timestamp format in the header for a syncsort program.
Could you pls help me out in that
I've been given the task to complete it by today.

Thanks
Technical questions are Not supported via PM. As has happened with you (for one thing) is that the one person you sent the PM may not be available. In my case I was stuck in the hospital for a couple of days. . .

We do not have the staff nor the intention to support forum dialog via PM. The forum is for every user not a one-on-one.

The duplicate of this topic has been deleted. Duplicate postings are not permitted and when dound, they are deleted.

Posted: Sun Apr 06, 2014 5:00 am
by DikDude
To do what you want get the timestamp you want from db2 and use this in the header.

Let sort generate the count in the trailer.

There are multiple examples of creating headers and trailers in the forum. When you have a problem, post what you tried and what happened.

Also, if is Not a good idea to come to a forum with something you want/need that day . . .

Posted: Mon Apr 07, 2014 1:23 pm
by NicC
In my case I was stuck in the hospital
Sorry to hear that DikDude - seems as though your typing digit is working fine - hope the rest of you is, too!

Posted: Mon Apr 07, 2014 9:47 pm
by DikDude
Thanks Nic.
hope the rest of you is, too
Workin' on it . . . :)