Help using Base SAS procedures

lib in SMC

Reply
N/A
Posts: 0

lib in SMC

I have created the DB2_Server , Db2_Schema and Library working fine under DB2Auth

Now I have added the connection object in DB2 Server for pointing it to defferent DataSrc: with same DB2Auth as before.

Add new Schema: pointing it to schema2
Library: db2libI2 as libref, server: DB2_Server , Schema2

I have created the different DB2 user group (Like DB2_user_group1, DB2_user_group2) for differnet Library which uses different login credential
and exist in DB2 Server as User.

Finally it throws this Message,

NOTE: Libref DB2LIBI2 was successfully assigned as follows:
Engine: DB2
Physical Name: ITERATE2
1 LIBNAME db2libI2 DB2 Datasrc=ABC2 SCHEMA=GR2 USER=user2 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXX ;


I have also tested this running (Display Libname) query from BASE/SAS on server it runs and but doesnot shows me tables.


but if I run this query from BASE/SAS on server it gives me result.

proc sql;
select * from db2libi2.Emp_master;
quit;

I am not understanding why it is happening.

Please let me know ,

Thanks
N/A
Posts: 0

Re: lib in SMC

I resolved... Case Sensitive on DB2 Schema Name.
Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 1 in conversation