DSXchange

Hi,

I have a requierment like i am extarcting the data from a query using teradata stage and in that for automation i need to pass year and month to the query.

The year and month should be pass from the sequencer becuase it will take the values when ever we run the seq and pass it to the job inside.


Please suggest ...?

Rd,
pradeep.

I suggest using DataStage job parameters for this.

Extract Date -----> Read file -------> Extract Query

Above the structure of the Job Sequence.
First you Extract the Date and write on to a file.

In the next stage you read the file using cat command in Execute command(ExecCommand).

And in the Extract Job write the below code in Value Expression in Job Activity.

Field(Convert(@FM, "", ExecCommand.$CommandOutput),',',1)

Note that there would be no need for the "extract date - write/read file" steps if you're just talking the current year / month. A routine could easily return them.

Hi Venkata,

If you need to pass current year and month from sequence as a parameter then you can use Oconv function in the expression grid of the Job activity.