Page 1 of 1

Assigning Date

Posted: Wed Aug 31, 2005 2:30 am
by gopskrish
Hi,

I am using Parameter file to get parameters for my jobs in the sequence. In that I am using from date and to date parameters. I am generating the dates using Unix scripts. Now i want to elliminate that and directly assign sysdate to the date parameters in datastage without using the file.
Throw me some light on that.

Best Regards,
Gopal

Posted: Wed Aug 31, 2005 2:47 am
by Sainath.Srinivasan
Use @date instead of the parameter.

Note - Pl post in the appropriate forum.

Posted: Wed Aug 31, 2005 2:59 am
by gopskrish
Hi Sai,

Thanks a lot for your immediate reply.
I will post it in correct forum hereafter.

Thanks again.

Best Regards,
gopal

Posted: Wed Aug 31, 2005 6:53 pm
by chucksmith
There is also the macro DSJobStartTimestamp that I use, since the data and time are constant for the run.

yah

Posted: Wed Aug 31, 2005 9:39 pm
by sasi_kumarreddy
u can user an function
iconv(date() ,'d ymd')