proc contents in SAS EG with connection to UNIX Db2 Tables
Posted on 2016-08-10
I am able to query a DB2 table from SAS EG using a connection to DB2.
I can assign a library using:
LIBNAME TST DB2 USER=&USR. PASSWORD=&PWD. DATASRC=&SRC.;
The problem is the lib is assigned but I do not see any tables.
Does anyone know what I need to do and is there a way to do a PROC CONTENTS?
I can query using this syntax:
Connect to db2(db=&SRC. user=&USR. pass=&PWD.);
Create table mytst as select * from connection to db2
(Select * from BM.TABLEA);
Disconnect from db2;
BM=Schema Table Name = TABLEA