How to add date as Low level qualifier to a dataset name?

Tamilarasi Manoharan · New User Joined: 11 Jun 2009 Posts: 1 Location: Chennai

Hi,

How to add current date as the Low level qualifier to a dataset name?
eg. "a.b.c.dt090611"

I used OPC option, as

//*%OPC SCAN
//*%OPC SETFORM OCDATE=(YYMMDD)
//*%OPC SETVAR TDAT2=(OCDATE-1CD)

and the dataset name as below

DSN=EORGA.AXXXX.DBA.CREDITS.DT&TDAT2,

But it shows an error as below.

STMT NO. MESSAGE
12 IEFC627I INCORRECT USE OF AMPERSAND IN THE DSN FIELD

Need help please!!!!

Regards,
Tamil.

Pedro · Posted: Fri Jun 12, 2009 10:36 am

Sorry, I do not know OPC so this advice might not apply.

I think the ampersands can only be used within a proc. You need to define the proc and then pass in the date as a parameter.

expat · Posted: Fri Jun 12, 2009 11:37 am

I think, from my distant memories of OPC, that maybe a different substitution symbol is used to substitute OPC variables.

Have a chat with your scheduling team and see if they know.

Anuj Dhawan · Posted: Fri Jun 12, 2009 11:37 am

If OPC is not the only option then there are plenty of working examples in this Forum for a similar request. Please seach the Forum.