lib in SMC

deleted_user — Mon, 19 Jan 2009 13:40:23 GMT

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

Re: lib in SMC

deleted_user — Tue, 20 Jan 2009 06:08:31 GMT

I resolved... Case Sensitive on DB2 Schema Name.

topic Re: lib in SMC in SAS Procedures

lib in SMC

Re: lib in SMC