db2 connection in sas pc

Accepted Solution Solved
Reply
Contributor
Posts: 46
Accepted Solution

db2 connection in sas pc

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


Accepted Solutions
Solution
‎01-27-2015 05:13 PM
Super User
Posts: 3,233

Re: db2 connection in sas pc

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.

View solution in original post


All Replies
Solution
‎01-27-2015 05:13 PM
Super User
Posts: 3,233

Re: db2 connection in sas pc

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.

New Contributor
Posts: 2

Re: db2 connection in sas pc

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 259 views
  • 3 likes
  • 3 in conversation