Do you know how I can get the date and time stamp into the dsn ?

[actionjack]

The symbolics &DATE and &TIME.

Do you know how I can get the date and time stamp into the dsn ?

maybe something like this ===> //SEND01 EXEC NDMXMT01,TEST='.TEST',DATE=?,TIME=?
is there something to pull the system date andtime stamp ?


//*
//JOBLIB DD DISP=SHR,DSN=DWS.PROD.PREEXEC
// DD DISP=SHR,DSN=DWS.PROD.PRDEXEC
//*
//SEND01 EXEC NDMXMT01,TEST='.TEST'
//DATE.SYSUT1 DD *
SUBMIT PROC=DSTCOPU1 -
NEWNAME=SETO - /* CHANGE WHEN IN PRODUCTION */
NOTIFY=%USER - /* REMOVE WHEN IN PRODUCTION */
&DATE=%JDATE -
&TIME=%SUBTIME -
&USERID=msrusr05 -
&DSN1=mainframe.file.name -
&DSN2=OTI.OTC.MSN.TIME.OTSC9999.R1.D&DATE..T&TIME -
CASE=YES -
HOLD=NO

 

[MarcLodge]

Actionjack,

Unless I'm mistaken, this is a product called Connect Direct, and is being executed from JCL on a mainframe.

First off, I would suggest a forum other than DB2.
Secondly, I would try what you've coded, and if it doesn't work, then post the errors you are receiving.

Marc