11-01-2011 07:40 AM
I have the following libname which connects to an SQL Server via OBDC;
libname servdat odbc dsn="MyODBC" uid=dbid pwd=pass ;
The tables on this server all have a period in their name, for example a.cus_data
The SQL is falling over as I belive that it sees this as a multi-level connection string.
proc sql ;
Is there a way I can get this to work?
Thanks in advance for any help.
11-01-2011 12:10 PM
Thanks Doc. This does the job nicely.
connect to odbc(user=myodbc password=mypass dsn="MYODBC");
create table outdat as
select * from connection to odbc
(select * from a.cus_data);
11-02-2011 04:23 AM
There is an option preserve_tab_names= . and Did you try 'a.cus_data'n this literal table name?
Need further help from the community? Please ask a new question.