SAS Code runs on Workspace Server but not on Stored Process Server

[Aasth]

Hi everyone,

I have a sas code that works well in the SAS workspace server but it cannot populate data on the tables when ran from the stored process server. It is the same code with the same username and password hard-coded for the sas db2 connection? Can anyone help me with this issue?

[VDD]

Does the server have DB2 installed?

or is the DB2 installed on your workstation and that is why it works!!!!

[Aasth]

Yes the server has DB2 installed and also DB2 is installed on my workstation. Other programs run its just this one thats not running

[SASKiwi]

Please post your Stored Process server SAS log for the program.

[Aasth]

I have attached a snip of the error . The username and password for making db connection is the same as it's the same program that runs in Workspace server.