Hi
I was trying to execute a shell script whose primary purpose is to truncate tables, drop indexes etc.
I defined
Before stage subroutine: 'ExecSH'
Input Value <shell-script-name.sh> -options
the script which i am pointing to actually is under oracle/bin directory.
1. I was wondering where would actually DS look for that script??
I mean in general whats the default directory does DS Engine look for that script other than the DS Repository.
2. If i want to point to the directory how can acheive it??
appreciate your help
Before/After Stage subroutines
Moderators: chulett, rschirm, roy
1. Wherever you tell it to look. Assuming a relative path, that would be controlled by your $PATH environment variable. In Windows it will look in your 'current working directory' first from what I recall, which for DataStage means the Project directory the job is running from, then check $PATH. It will not look in 'the repository'.
2. Supply the full path to the script.
2. Supply the full path to the script.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers