topic Re: Systask return code in SAS Programming

Systask return code

helannivas88 — Wed, 27 May 2020 17:06:17 GMT

Hi,

I have a systask command running in SAS EG where I'm launching a DB2 clpplus inside that. Below is the command

systask command "echo 'password' | clpplus -nw user@dsn @/home/test.sql"
NOWAIT STATUS=T1_RC TASKNAME=T1_TASK SHELL="bash";
WAITFOR T1_TASK;

%PUT NOTE: RC = &T1_RC;

The above command is exactly correct and if I run , I'm getting the output what Im expecting and T1_RC ouput as 0.

Even when I had the wrong password in the command, the sas logs shows me as Invalid password. But still the return code is zero. Im not able to differentiate success/ failure with this return code.

IS there any other way to capture the return code from systask command?? Please let me know

Thanks

Re: Systask return code

ChrisNZ — Thu, 28 May 2020 05:26:24 GMT

The return code informs you about the success of the command.

The echo command doesn't fail, and the RC correctly tells you that.

You might want to use the pipe engine to run the command, and look at the OS output to assess the result.

Re: Systask return code

helannivas88 — Thu, 28 May 2020 06:41:50 GMT

Thanks Chris...Can I have an example please???

Re: Systask return code

ChrisNZ — Thu, 28 May 2020 23:06:51 GMT

Maybe something like:

filename CMD pipe  "echo 'password' | clpplus -nw user@dsn @/home/test.sql";
data _null_;
  infile CMD;
  input;
  putlog _INFILE_ ;
  *if _INFILE_ = .. .then ...; 
run;