Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
How to get current timestamp using Sort Utility.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 184
Location: Hyderabad

PostPosted: Tue Dec 13, 2005 9:09 pm    Post subject: How to get current timestamp using Sort Utility.
Reply with quote

Hi ALL,

I have got a requirement to reformat the record which has time stamp.
so i am using sort utility with out rec option. but i want current time stamp(i.e the time the job has run). currently iam hard coding time stamp.

SYSIN looks as
//SYSIN DD *
SORT FIELDS=(1,9,CH,A)
OUTREC FIELDS=(1,9,10:C'2005-09-01-10.32.00.000000')
instead of hard code timestamp i want current timestamp.

Please if any one has idea let me know.

Thanks in advance.
Jai
Back to top
View user's profile Send private message
References
priyesh.agrawal

Global Moderator


Joined: 28 Mar 2005
Posts: 1509
Location: Chicago, IL

PostPosted: Tue Dec 13, 2005 9:21 pm    Post subject: Re: How to get current timestamp using Sort Utility.
Reply with quote

Is this what u need.....

http://www-03.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst03.html#t06

Regards,

Priyesh.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 4684
Location: San Jose, CA

PostPosted: Tue Dec 13, 2005 9:46 pm    Post subject:
Reply with quote

Jai,

You can use the following DFSORT OUTREC statement to get what you asked for:

Code:

   OUTREC FIELDS=(1,9,10:DATE4,C'.000000') 


DATE4 produces a date of the form 'yyyy-mm-dd-hh.mm.ss'.
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 184
Location: Hyderabad

PostPosted: Tue Dec 13, 2005 9:48 pm    Post subject: Re: How to get current timestamp using Sort Utility.
Reply with quote

priyesh.agrawal wrote:
Is this what u need.....

http://www-03.ibm.com/servers/storage/support/software/sort/mvs/tricks/srtmst03.html#t06

Regards,

Priyesh.
Thanks Priyesh
Regards
jai
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1