topic db2 connection in sas pc in SAS Programming

db2 connection in sas pc

Armand — Tue, 27 Jan 2015 20:33:47 GMT

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

Re: db2 connection in sas pc

SASKiwi — Tue, 27 Jan 2015 22:13:04 GMT

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.

Re: db2 connection in sas pc

rosietav — Mon, 02 Feb 2015 19:32:36 GMT

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;