Good Morning,
I'm trying to access different tables from different servers, but when I connect to the 'second' server I lose the connection from the first!
I connect to the 'first' server with:
%let rsas=xxx.xxx.xxx.xxx;
options comamid=tcp;
signon rsas.spwn user=_prompt_;
TABLE1 is on my own library stated as:
rsubmit;
libname lib1 'ucdmpwk.dw.lib1' disp=old;
endrsubmit;
libname lib1 server=rsas.spwn;
After creating a table (TABLE1) in lib1 library with this connection, I want to be able to access another table. Then I connect to this:
%let rsasaix=xxx.xxx.xxx.xxx xxxx;
options remote=rsasaix comamid=tcp;
filename rlink "!sasroot\connect\saslink\tcpunix.scr";
signon rsasaix user=_prompt_;
TABLE2 is in this library:
rsubmit;
LIBNAME DEP DB2 USER=XXXXXXX PASSWORD=XXXXXXX
PRESERVE_COL_NAMES=YES PRESERVE_TAB_NAMES=YES
SCHEMA=prod DATASRC=prod;
endrsubmit;
libname DEP server=rsasaix;
let's say I have the same column in the two tables.
what I want to do is something like this:
select *
from
lib1.TABLE1 a,
DEP.TABLE2 b,
where
a.col1 = b.col1
ERROR: Libname LIB1 is not assigned.
ERROR: File DEP.TABLE2.DATA does not exist.
Thanks in advance
Pintarolas