Ecxecuting Shell Script in Datastage Jop properties

mdtauseefhussain · Post by **mdtauseefhussain** » Sat Oct 07, 2006 3:50 am

HI! All

I have a shell script Sample.sh,when i try to put this script in Exec Sh option in Job properties
iam getting an error
"cannot find Sample.sh

the script is working fine when i run from the particuar folder where the script resid

i tried to execute the script this way

home/staff/thussain/tausif/Sample.sh

when i trie running this scritp in datastage ,iam getting this error

Executed: /home/staff/thussain/tausif/Sample.sh
Reply=0
Output from command ====>
split: No such file or directory
find: cannot read dir ./sot.aOSN: Permission denied
find: cannot read dir ./sowHaOeQ: Permission denied
find: cannot read dir ./sosEaOve: Permission denied

Can any help me executing this script

ArndW · Post by **ArndW** » Sat Oct 07, 2006 6:58 am

Never assume a CWD in scripts. The CWD of any script called from DataStage will be the directory where the project is installed. If you use an absolute path for all references or you change your working directory explicitly inside the script you will be OK

ray.wurlod · Post by **ray.wurlod** » Sat Oct 07, 2006 8:37 am

Similarly, the executing DataStage job assumes that your script is in the project directory if it's not given as a pathname and it's not findable via the PATH environment variable.

kumar_s · Post by **kumar_s** » Sun Oct 08, 2006 1:15 am

So you need to workout in you script to make sure, the paths refered as the absolute path.

Kirtikumar · Post by **Kirtikumar** » Mon Oct 09, 2006 12:34 am

From the error shown it also means - the script is trying to read/use the directories mentioned int the error message. The user with which you logged in Datastage do not have permissions on directory.

Is the username with which you are loggin in DS and unix is same?
Have you tried executing this script from unix prompt first? It is always a good practice to execute any script on unix that is called from DS jobs.

chulett · Post by **chulett** » Mon Oct 09, 2006 7:28 am

Kirtikumar wrote:It is always a good practice to execute any script on unix that is called from DS jobs.

Good practice, yes - but don't make the mistake that just because it runs from the command prompt that it must work fine from a DataStage job! All of the above issues apply that could cause one way to work and the other to not.

Kirtikumar · Post by **Kirtikumar** » Mon Oct 09, 2006 10:42 pm

Agreed!!!

Good practice can just reduce the chances of common errors.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 10, 2006 1:42 pm

The find command is having permissions problems. You should also verify that the user ID under which DataStage jobs execute have at least r-x permission to all directories in the pathname(s) to be searched.

rameshrr3 · Post by **rameshrr3** » Wed Oct 18, 2006 5:18 am

Try this

Code: Select all

ksh "YOUR COMMAND, WITH ABSOLUTE PATH"