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
- 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
- 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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
adityavarma
- 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
- 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
- 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
- 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
- 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
- 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.
-craig
"You can never have too many knives" -- Logan Nine Fingers