db2 connection in sas pc

[Armand]

hello

i am trying to connect to a database via db2. the following is my code and store the result into MYWORK :

rsubmit;

libname mywork 'h:\user\my document\myfile';

%let mydbpasswd=%str({sasenc}12222222222221);

proc sql;

connect to db2 (dsn="table" user=ismine pass=&mydbpasswd");

create table mywork.status as

    select * from connection to db2

          (select prod_id, prod_name,status from table1);

disconect from db2;

quit;

endrsubmit;

The log reproduced my code and and finish by "Remote submit to SASGRID complete",

  I cannot find mywork library i created neither a data( dataset Status).

Any help?  Thank you in advance

[SASKiwi · Accepted solution]

The MYWORK library is stored on the SAS server you did a remote submit to not your PC.

Since your server appears to use Windows you could try a UNC in Windows Explorer along the lines of: \\SASServerName\HDrive\user\my document to get to that folder location. You will need to substitute SASServerName and HDrive with the names that will work on your server.

[rosietav]

I agree with SASKiwi. It looks like you need to change your libname path to refer to your server file path. Something like:

%let serverinfo=xxx.xx.com;

libname mywork '/user/mywork' server=serverinfo;