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.
How to pass year and month fro ma sequencer to the job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Tue Jul 27, 2010 5:50 am
- Location: bangalore
How to pass year and month fro ma sequencer to the job
p.v.pradee preddy
I suggest using DataStage job parameters for this.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 96
- Joined: Mon May 14, 2012 1:30 pm
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)
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)
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.
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.
Code: Select all
Oconv(Date(),"DYM[4,2]")