DSXchange

Hi All,
Im trying to execute a unix script through 'execute command' stage . No other stages used. The value given in the command tab is : sh /rdw/prd/CIS/SCRIPTS/DDD.sh
In the parameter section value is : #ScriptDateValue#(which is JUL-2011,partitionvalue of the table).
The script is suppose to insert data into few tables.

Datastage job finishes with no error. But data is not loaded in the tables.
While if i trigger the same script though unix its executing successfully.

The logs in the director are as below:
mthly_test2..JobControl (@sh): Executed: sh /rdw/prd/CIS/SCRIPTS/DDD.sh JUL-2011
Reply=127
Output from command ====>
/rdw/prd/CIS/SCRIPTS/DDD.sh[4]: sqlplus: not found
Can anybody help me with this?

Within your Developement environment, you might want to put in some debuging statements.

Your script executed, but the environment is not set up properly.

Are you executing the script with your user id from the command line?
When you execute via the tool, are you credentially mapped to a different user id?

In your script, do an echo on your environment variables.
Compare that to your command line environment.

poorna.ds wrote:sqlplus: not found

Help it be found, use a full path to the executable or add where it lives to your $PATH variable. Standard 'Command Line 101' stuff.