To run a job based on the output of the first job

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

Post by adityavarma »

the problem is with the below command in the execute command activity.
Command: cat
Parameters: <filename>


The output of this command is giving one extra line in the output because fo which the trigger is not able to pick it

is there any way in the execute command activity to ignore that line and to display the output command in only one line.

Regards,
Aditya
swathi Singamareddygari
Participant
Posts: 48
Joined: Fri Feb 29, 2008 1:09 am
Location: Bangalore

Post by swathi Singamareddygari »

When you execute any unix command there will be Field marker at the end of the output,so try converting it to empty in user variable avtivity.

Convert(@FM,'',Command.output) and use this output to your job.
Thanks&Regards
S.Swathi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Which is exactly what I posted earlier. My syntax should have worked for that as well as the EReplace() as long as the correct syntax is used. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

Post by adityavarma »

Thank you all.

The issue is resolved now.

But still one more issue is there , i am not able to pass the parameters to execute command acitivity from the Parameter set.

Is this not poosible in the execute command acitivity.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Post your syntax.
-craig

"You can never have too many knives" -- Logan Nine Fingers
adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

Post by adityavarma »

Convert(@FM,'', Exec_batch_STATUS.$CommandOutput) = "SUCCESS"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I was looking for the syntax for this:
adityavarma wrote:But still one more issue is there , i am not able to pass the parameters to execute command acitivity from the Parameter set.
-craig

"You can never have too many knives" -- Logan Nine Fingers
adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

Post by adityavarma »

Craig,

Two days back, i am unable to pass in the parameters from the Parameter set to the execute command activity for the cat command.


But now i am able to pass the parameters from the parameter set.

Dont know how yesterday i am able to pass the parameters from the paramert set and why i didnot get them the day before??

It is very strange for me..... :?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

OK... then I guess we really are resolved here now. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply