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
 

 

Previous Date to be appended in OUTREC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
arunjosephaj

New User


Joined: 21 Mar 2006
Posts: 20
Location: India

PostPosted: Fri Sep 29, 2006 3:55 pm    Post subject: Previous Date to be appended in OUTREC
Reply with quote

Hi..
I know that it's possible to append the current date to the end of each record in the input file and copy it to the output file using the DATE parm in OUTREC. I have a requirement, in which I want the previous day's date to be appeneded instead of current date. Is this possible?
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


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

PostPosted: Fri Sep 29, 2006 8:29 pm    Post subject:
Reply with quote

You can use DFSORT's relative date support in INREC, OUTREC and OUTFIL to do that. For example:

Code:

   INREC OVERLAY=(81:DATE1-1)


would give you '20060928' in positions 81-88 today. There are lots of other variations you can use for other date formats.

You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's relative date function. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:

www.ibm.com/servers/storage/support/software/sort/mvs/peug/
Back to top
View user's profile Send private message
arunjosephaj

New User


Joined: 21 Mar 2006
Posts: 20
Location: India

PostPosted: Sat Sep 30, 2006 10:09 am    Post subject: Re: Previous Date to be appended.. Plz help..
Reply with quote

Thnkx a lott.. i will give it a try.. ya i know abt the date formats.. and i even tried this -1 but didnt work i guess.. but will try once more.. or ask my system admin.. is there any way i can know if z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) is already istalled?
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Sat Sep 30, 2006 9:30 pm    Post subject:
Reply with quote

Quote:
is there any way i can know if z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) is already istalled?


Yes, look at the messages from any DFSORT run. If you see 'ICE201I E', you have the April, 2006 PTF. If you see 'ICE201I 0', you don't have the PTF.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts SUBSTR for Date functions Shaheen Shaik DB2 4 Thu Apr 06, 2017 2:14 pm


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