"Run Program" activity and return value

Toad Data Point
1

Hi,

I am trying capture return value from an external program (Java). The program returns expected values on command prompt and in TDP, however it ends with a failure.

In “Run Program” activity, Return code is to be assigned to “Run_1_Code” variable. Then I have if condition to see what value is returned. But the execution fails at “Run Program” activity.

Any suggestions/ideas.

Thanks,

2

Hi,

Sorry that I posted this before googling, found the solution at: http://dev.toadfordataanalyst.com/webhelp/default.htm#Automation/Use_System_Automation_Activities.htm

under “Run Program” stating:

“Return code (exit code) values of 16384 (4000 hex) or larger do not generate a script error in this activity. Other return code values do. This allows you to use your program to generate a custom return code value in this range and use it in subsequent activities without generating a script error.”

Thanks,