DATA Step, Macro, Functions and more

libname odbc intersystems

Reply
Occasional Contributor
Posts: 14

libname odbc intersystems

Hi,

 

I created an odbc intersystems cache library but I can't see any table.

 

could you help me

Thx

 

Super User
Posts: 5,429

Re: libname odbc intersystems

Step one, test from a non-SAS client on the same machine. Like Excel.

Then there can be tons of reasons: authorization, source table names not comply with SAS naming conventions (table names longer than 32 char as an example).

Also, check with the DBA if they can spot any messages during your access.

Can you perform an explicit SQL pass through?

Data never sleeps
Occasional Contributor
Posts: 14

Re: libname odbc intersystems

Thx for your replay.

I don't have the name of the tables in order to do this test. 

Super User
Posts: 3,252

Re: libname odbc intersystems

So how did you create this? In code, in SAS Management Console, or some other means? Without details of how you set this up we can only guess what might be wrong.

Occasional Contributor
Posts: 14

Re: libname odbc intersystems

Hi,

 

I created the librairy in Management console, everything is correct.

 

Thx

Super User
Posts: 5,429

Re: libname odbc intersystems

Say what now? So how do you even know that there are any tables? In order to trouble shoot this you need help from people on the DB side.
Data never sleeps
Occasional Contributor
Posts: 14

Re: libname odbc intersystems

Ok Thx,

I will see with DBA team

Ask a Question
Discussion stats
  • 6 replies
  • 140 views
  • 0 likes
  • 3 in conversation