DSXchange

Hi,

I have a situation where I have to extract data from a oracle table which are generated daily with name as "table_mmddyyyy" so if I can pass yesterday's date as parameter in the extarction job then I can select the table which is created yesterday.

How can I pass that automatically at run time?

Pl help.

Regards
Om

If you're passing a parameter to the job you have to pass it from somewhere - perhaps a job sequence, perhaps a shell script. It's there that you generate yesterday's date. In a job sequence a suitable expression is (Adjust the specification to suit requirements.)

ray.wurlod wrote:If you're passing a parameter to the job you have to pass it from somewhere - perhaps a job sequence, perhaps a shell script. It's there that you generate yesterday's date. In a job sequence a suitable expression is

Code: Select all

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

(Adjust the specification to suit requirements.)

Thanks for the prompt reply ray,
I have a shell script written which can generate yesterday's date in the format I want. How do I pass it in parameter?

Regards
Om

You can have as many -param name=value options as needed.

Create a parameter for table name.
In Job Sequence Value expression where parameters value is passed, use TAB:Oconv(Date()-1,"DMDY[2,2,4]")
Where TAB is the parameter for the table name.

Oops a late reply

kumar_s wrote:Oops a late reply

Hi Kumar,
Your solution looked intresting, but geting the following date format but I dont want the space in between.

"03 05 2006" I want>> "03052006"

Regards
Om

Hi Om,

Wrap Kumar's Function call in ereplace like:
to replace all spaces to Empty Strings.

ameyvaidya wrote:Hi Om,

Wrap Kumar's Function call in ereplace like:

Code: Select all

EREPLACE(Oconv(Date()-1,"DMDY[2,2,4]"),' ','')

to replace all spaces to Empty Strings.

Done...
Thanks a Lot !

More efficient is (I assume this expression is in a job sequence; Oconv() is not available in parallel jobs but is available in job sequences.