DSXchange

Hi Guys,

I have shell script which is calling Datastage job and is running perfectly.
The problem is the parameters needed are in a Oracle table which i need to fetch.
I am able to fetch them if i write in a separate script,but when i include the same code in the script which is calling Datastage (sourcing dsenv file), the sql is failing with the below errror. My guess is dsenv is changing some of the required params for Oracle. Has anybody included a SQL command in a Datastage calling Script.

Please guide me as what i am doing wrong.

Cheers!!!!

Make sure you have ORACLE_HOME and ORACLE_SID variables properly set for the environment.

then use sqlplus -s username/pwd comnd for logging
after that u can just type SQL cmnds directly.

e.g:-

sqlplus -S $user/$pass <<EOF
SELECT * FROM tableName;
exit;
EOF

If you still have an issue, suggest you post the relevant section of your script.