DSRoutine

narasimha · Post by **narasimha** » Wed Dec 20, 2006 11:00 pm

Check if this works
Execute_Command_12.$CommandOutput=0 (Link1)
Execute_Command_12.$CommandOutput=1 (Link2)

If it does not work try
Execute_Command_12.$CommandOutput<1>=0 (Link1)
Execute_Command_12.$CommandOutput<1>=1 (Link2)

kumar_s · Post by **kumar_s** » Wed Dec 20, 2006 11:05 pm

I could just see that you have mentioned "*** No output from command *** ", so check the command that been executed from DS Director, and execute the same command from command line. By some chance expected paramter might not be passed.

pradkumar · Post by **pradkumar** » Wed Dec 20, 2006 11:13 pm

I am getting the following log in the director:

Executed: cat /Ascential/DataStage/Projects/filename
Reply=0
Output from command ====>
0

Executed command: /Ascential/DataStage/Projects/sendmail_Jseq_Routine_Test76201_4368.sh
*** No output from command **

narasimha · Post by **narasimha** » Wed Dec 20, 2006 11:19 pm

Looks like you are getting the output. i.e 0
Change the contents of your filename manually to say 1
Run your execute command
You should get

Output from command ====>
1

pradkumar · Post by **pradkumar** » Wed Dec 20, 2006 11:22 pm

Yes Narasimha,

I am getting 1

narasimha · Post by **narasimha** » Wed Dec 20, 2006 11:32 pm

narasimha wrote:Check if this works
Execute_Command_12.$CommandOutput=0 (Link1)
Execute_Command_12.$CommandOutput=1 (Link2)

If it does not work try
Execute_Command_12.$CommandOutput<1>=0 (Link1)
Execute_Command_12.$CommandOutput<1>=1 (Link2)

Try these, and see if you get results.

pradkumar · Post by **pradkumar** » Wed Dec 20, 2006 11:42 pm

one intersting thing is happening when I mention the Trigger condition as you mentioned in first set.
Execute_Command_12.$CommandOutput=0
Execute_Command_12.$CommandOutput=1

ie" I am not getting any email"
I gave the output links to 2 notification activities. I am not getting nay email now.

Previosuly when I used "
Execute_Command_12.$CommandOutput<>0 (Link2)

I used to get emails.

chulett · Post by **chulett** » Wed Dec 20, 2006 11:44 pm

As I've already mentioned twice now, you'll need to use the second syntax in the previous post. Output from a command execution is returned in a dynamic array and the Field Marks are messing you up. If you check the first array element by adding <1> to the end of the variable, you'll just get the '0' or the other numbers you are expecting.

And I suggest you stick with these checks based on your previous comments:

Code: Select all

Execute_Command_12.$CommandOutput<1>=0 (success link) 
Execute_Command_12.$CommandOutput<1>#0 (failure link)

Of course, you could use an Otherwise trigger for the failure link which would be my preferred methodology.

pradkumar · Post by **pradkumar** » Wed Dec 20, 2006 11:50 pm

Thanks all of you for your ideas.

I got the answer with the second choice mentioned by Narasimha and Criag.

Thx once again

ray.wurlod · Post by **ray.wurlod** » Thu Dec 21, 2006 12:43 am

Then please mark the topic as Resolved.