how to get the output of the unix command:'echo "obase=

[lynnliu]

hi,

i want to get the 36 base decimal through the unix shell like bellows,

Code: Select all

$echo "obase=36;99999999999"|bc

in DataStage routine using

Code: Select all

InputArg = 'echo "obase=36;'
InputArg = InputArg : LongNum: '"|bc'
Call DSExecute("UNIX",InputArg,Output,SystemReturnCode)

But i can not catch the output of the shell.
How to catch the output of this kind of shell?

Regards
Thanks!!

[ogmios]

It's your output argument.

Put a DSLogInfo using output after executing the instruction.

Also watch out that anything you run with DSExecute runs using a very minimal UNIX environment unless you make changes to your DataStage installation.

Ogmios

[Amos.Rosmarin]

meaning

Code: Select all

Call DSLogInfo ("output is - " : Output , '')

and you'll see it in the log




HTH

[lynnliu]

sorry, i didn't explain clearly.

i know that the output in the Output argument.
i using DSLogInfo in my routine

Code: Select all

call DSLogInfo("*** Output from the command was: ":Output, RoutineName)

i got only one blank space in Output.

if the command like this :

Code: Select all

'echo 9999'

,the Output return "9999". I don't know how to get the result of this command

Code: Select all

 $echo "obase=36;9999"|bc

Thanks!!

[magma]

works for me if I try...

echo "obase=36 \n 9999" | bc

[ray.wurlod]

$echo is a reference to a shell variable. Perhaps that shell variable is not defined, or has "" assigned to it? This would be a "do nothing" command with no output.

Try it without the $ character at the beginning.

[lynnliu]

Michael, you mean you can get the same output in DSExecute as in terminal? My problem is it works well in terminal but not in DSExecute.
Ray, i didn't use "$" in my routine. i used it to explain the shell command in last post . Is the problem of double quotation marks or pipe operator?

[lynnliu]

The Problem solved!! Thanks All!!

i change the command to

Code: Select all

echo 'obase=36;9999'|bc

In DSExecute:

Code: Select all

call DSExecute("UNIX","echo 'obase=36;9999'|bc",Output,SystemReturnCode)

it works!!