Assigning Date

gopskrish · Post by **gopskrish** » Wed Aug 31, 2005 2:30 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Aug 31, 2005 2:47 am

Use @date instead of the parameter.

Note - Pl post in the appropriate forum.

gopskrish · Post by **gopskrish** » Wed Aug 31, 2005 2:59 am

Hi Sai,

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

Thanks again.

Best Regards,
gopal

chucksmith · Post by **chucksmith** » Wed Aug 31, 2005 6:53 pm

There is also the macro DSJobStartTimestamp that I use, since the data and time are constant for the run.

sasi_kumarreddy · Post by **sasi_kumarreddy** » Wed Aug 31, 2005 9:39 pm

u can user an function
iconv(date() ,'d ymd')

DSXchange

Assigning Date

Assigning Date

yah