Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
kishoreramachandran
Participant
Posts: 88 Joined: Tue Nov 28, 2006 9:33 pm
Post
by kishoreramachandran » Mon Jan 22, 2007 10:09 am
I have got 2 values in 2 different tables which has to be passed as parameters to a set of jobs in job sequencer.how to do this. any of the jobs in the job sequencer should be able to access this values.
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Jan 22, 2007 10:41 am
Load them into a file. Use cat filename.txt to read the contents of that file via Execute Command Stage and pass it to your sequence job. Just covered this over the weekend. Refer
here for details.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kishoreramachandran
Participant
Posts: 88 Joined: Tue Nov 28, 2006 9:33 pm
Post
by kishoreramachandran » Mon Jan 22, 2007 11:19 am
the 2 values will be from 2 different tables, then should I have 2 txt files.they are different columns, 1 is a date and other is a integer
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Jan 22, 2007 11:22 am
You can have as many different files as you want. Just make sure you cat the correct file for the correct parameter value.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Jan 22, 2007 1:09 pm
Yes. The one thats present in the sequence job.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kishoreramachandran
Participant
Posts: 88 Joined: Tue Nov 28, 2006 9:33 pm
Post
by kishoreramachandran » Mon Jan 22, 2007 1:18 pm
i created a execute command job and gave the full path name of the sequential file preceeded by the word type in the command box and executed it and it says file not found but the file is present.
us1aslam1us
Charter Member
Posts: 822 Joined: Sat Sep 17, 2005 5:25 pm
Location: USA
Post
by us1aslam1us » Mon Jan 22, 2007 1:24 pm
what command are you using?Are you specifying the parameters properly? Do check that.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
kishoreramachandran
Participant
Posts: 88 Joined: Tue Nov 28, 2006 9:33 pm
Post
by kishoreramachandran » Mon Jan 22, 2007 1:27 pm
i have created an execute command job and have given cat filename, now after that I have got a job activity in the job sequence that is calling this execute command job, but how do i associate the job parameter with the value coiming from the sequenctial file.
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Jan 22, 2007 1:34 pm
Did you read that post that i embedded in my very first reply ?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kishoreramachandran
Participant
Posts: 88 Joined: Tue Nov 28, 2006 9:33 pm
Post
by kishoreramachandran » Mon Jan 22, 2007 1:36 pm
yed, do only i have something.
what should I give in the job properties of the sequence job.
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Jan 22, 2007 1:46 pm
You must have missed the second page. This is a direct copy paste from there:
Inside the jobactivity, where your specifying $CommandOutput, provide the following
Code: Select all
Field(Execute_Command_2.$CommandOutput,@FM,1)
OR simply
Code: Select all
Execute_Command_2.$CommandOutput<1>
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.