IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Reading an input file with a DSN containing System date


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
gaylesmith

New User


Joined: 25 May 2007
Posts: 5
Location: los angeles, CA

PostPosted: Sat Jan 24, 2009 12:01 am
Reply with quote

We have a new eCommerce interface that PUTS files to our mainframe daily with the DSN containing the a date. And, we have no control on the DSN they provide us. Their policy is to put the date on the file.

I need assistance on methods to use this file as input for CA-7 scheduled job.
I thought of using symbolics, but we want to eliminate any manual interface to the job. So that, no one has to change the date each day.

For Example:
Monday, the file is put to the mainframe as L2G.TTC.REFUND.JAN1909
Tuesday, the file was put as L2G.TTC.REFUND.JAN2009
Wednesday, the file was put as L2G.TTC.REFUND.JAN2109

So, on Monday, when our job runs, it would use as input L2G.TTC.REFUND.JAN1909
Tuesday, it would use L2G.TTC.REFUND.JAN2009

And, we don't want to manually update the jcl prior to execution.

Any suggestions?
Thank-you!
Gayle
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA

PostPosted: Sat Jan 24, 2009 12:06 am
Reply with quote

Look in your CA-7 documentation for the CARPROC CA-7 driver procedure -- I believe it's in the Interfaces manual. CARPROC allows you to specify various date formats for file names, but is specific to CA-7.
Back to top
View user's profile Send private message
gaylesmith

New User


Joined: 25 May 2007
Posts: 5
Location: los angeles, CA

PostPosted: Sat Jan 24, 2009 12:34 am
Reply with quote

Thank-you for your suggestion.

I will speak with the CA-7 support unit and see if they know about this feature, or have documentation for me to look at.

Still open to other suggestions.

Gayle
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Binary File format getting change whi... All Other Mainframe Topics 7
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
Search our Forums:

Back to Top