To call a shellscript within User Defined Server Routine

prem84 · Post by **prem84** » Mon Aug 30, 2010 6:48 am

Hi,
I have a shellscript.
It needs to be called from a user defined subroutine.
How can i do it.

chulett · Post by **chulett** » Mon Aug 30, 2010 6:48 am

DSExecute()

prem84 · Post by **prem84** » Mon Aug 30, 2010 6:53 am

But the documentation says DSExecute executes a datastage engine command or a Dos command and no reference to shellscript execution is given

chulett · Post by **chulett** » Mon Aug 30, 2010 7:11 am

It executes all kinds of things, including any operating system command and you would specify 'UNIX' as the type for a shellscript rather than 'DOS' (etc). Is your DataStage server actually running on a UNIX box?

ray.wurlod · Post by **ray.wurlod** » Mon Aug 30, 2010 5:53 pm

The first argument of DSExecute() is the shell in which the command is to execute. It might be "SH" (on UNIX), "DOS" (on Windows) or "UV" (for the UniVerse shell).

chulett · Post by **chulett** » Mon Aug 30, 2010 8:32 pm

Ah... been awhile, forgot the 'SH' rather than 'UNIX' part.

kduke · Post by **kduke** » Tue Aug 31, 2010 4:45 am

execute 'SH -c "unix command" ' capturing output returning ReturnValue

prem84 · Post by **prem84** » Thu Sep 02, 2010 7:20 am

Hi all,
Thank you very much now i am able to call the shellscript.
Suppose i need to pass a argument to the DSexecute command from a function i.e.
s = Arg1
Call DSExecute('UNIX','sh check.sh s',Output, SystemReturnCode)
But i am not able to pass the actual value.
Kindly advice.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Sep 02, 2010 7:29 am

That is because you are giving 's' within quotes which will interpret as a literal string.

Try

Code: Select all

'sh yourShellScript ': s

arunkumarmm · Post by **arunkumarmm** » Wed Sep 08, 2010 10:53 am

prem84 wrote:Hi all,
Thank you very much now i am able to call the shellscript.
Suppose i need to pass a argument to the DSexecute command from a function i.e.
s = Arg1
Call DSExecute('UNIX','sh check.sh s',Output, SystemReturnCode)
But i am not able to pass the actual value.
Kindly advice.

May be try something like this

Code: Select all

 
vCmd = 'sh check.sh' : s
Call DSExecute('UNIX',vCmd,Output, SystemReturnCode)