Date

[pp]

Is there an environment variable or any other way where we can get the current date as a parameter?

[mallikarjuna36]

yes.

study parallel extender PDF .

in that you can find this.

[ray.wurlod]

Can you be more specific about your use of the term "parameter"? Is this a job parameter, or do you simply need the current date within your job design? Either is possible, but we'd prefer to answer the correct question.

[pp]

I have an input file name of which the date is a part.
An example file name is: abc102307
(102307 which is todays date.)

I know that we have date functions which we can use but that would be in the transformer. I would like to get the current date incorporated as a part of the filename before any processing starts.
So, I was thinking if we there was any environment variable which could accomplish this.

Thanks.

[ray.wurlod]

You can pick up the date from the @DATE system variable when assigning the job parameter value in your job sequence. You probably want to convert this to a "human readable" format in the assignment expression, for example

Code: Select all

Oconv(@DATE,"D-YMD[4,2,2]")