Run shell script(fr Ds) that contains a call to sqlplus
Posted: Fri Oct 28, 2005 5:08 am
Hi,
I am running a simple shell script through Datastage as a BEFORE ROUTINE.
This is the script.
sqlplus -s username@engt1/password <<EOF
execute useradmin.msp_loader.drop_index('rnkt0','attendance',null,'ALL');
EOF. I have put this in a shell script called drop_index.ksh and it is present in the path /app03/engineering/dpr on my unix box. So I am executing the shell script as BEFORE ROUTINE(ExecSH).But I get the following error
Afterjobroutine..BeforeJob (ExecSH): Error when executing command: /app03/engineering/dpr/drop_index.ksh
*** Output from command was: ***
/app03/engineering/dpr/find_date.ksh: sqlplus: not found. I searched the forum and got the below result. But I really couldn't fix my problem with the below solution
viewtopic.php?t=89449&highlight=sqlplus%3A+not+found
Can anyone of you please let me know what can be done about this?
Thanks in Advance.
Regards,
Dprasanth
I am running a simple shell script through Datastage as a BEFORE ROUTINE.
This is the script.
sqlplus -s username@engt1/password <<EOF
execute useradmin.msp_loader.drop_index('rnkt0','attendance',null,'ALL');
EOF. I have put this in a shell script called drop_index.ksh and it is present in the path /app03/engineering/dpr on my unix box. So I am executing the shell script as BEFORE ROUTINE(ExecSH).But I get the following error
Afterjobroutine..BeforeJob (ExecSH): Error when executing command: /app03/engineering/dpr/drop_index.ksh
*** Output from command was: ***
/app03/engineering/dpr/find_date.ksh: sqlplus: not found. I searched the forum and got the below result. But I really couldn't fix my problem with the below solution
viewtopic.php?t=89449&highlight=sqlplus%3A+not+found
Can anyone of you please let me know what can be done about this?
Thanks in Advance.
Regards,
Dprasanth