reading a file from unix server into a variable

[altruist]

Hi Everyone,


In routines, i am using

Code: Select all

      UnixCmd="cat ""\PATH":"Filename"
Call DSU.ExecSH(UnixCmd,Error)

I need to have the value read from the file in order to return it from routine. So taht I can use it in my jobs.

How can I get the result of the executed command

Thanks a Lot

[kcbland]

Code: Select all

UnixCmd="cat ""\PATH":"Filename" 
Call DSExecute("UNIX", UnixCmd,ScreenOutput, ReturnCode)

ScreenOutput will be a dynamic array, where every line in the output is a line in the array. Read up on DSExecute in your DS BASIC manual.

[altruist]

I used the following code

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

dump=Arg1
Ans=0

      UnixCmd="cat /nz/etl/dev/wrk/pwd_mms_etlext"
      Call DSU.DSExecute("UNIX",UnixCmd,SystemOutput,ErrCode)
Ans=SystemOutput

But it gives the following errors

Code: Select all

Program "DSU.TryUnix": Line 8, Unable to open the operating system file "DSU_BP.O/DSU.DSExecute".
[ENOENT] No such file or directory
Program "DSU.TryUnix": Line 8, Unable to load file "DSU.DSExecute".
Program "DSU.TryUnix": Line 8, Unable to load subroutine.

Anything wrong with what i am doing???????

[ArndW]

Just call DSExecute from your routine.

[kcbland]

Oops, I corrected the original post, you don't need the INCLUDE statement you added as well.

[altruist]

what is the difference between DSU and without DSU?

Thought for any datastage provided routines we need to use DSU.

Its working right now

Thanks

[kcbland]

what is the difference between DSU and without DSU?

Functions need a declaration, but DSExecute is a Routine and therefore CALL'ed. Custom functions using other custom functions or job control API functions need the INCLUDE and DEFFUN statements. Custom subroutines are actually saved with a "DSU." prefix.

[ray.wurlod]

Supplied functions (those in on-line help and manuals) don't need a prefix.