topic SQL Anywhere data in Administration and Deployment

SQL Anywhere data

sid3284 — Fri, 21 Jun 2019 14:40:20 GMT

Hi,

We are connecting to SAP SQL anywhere database from SAS to read data.

We can create the connection through libname statement.

LIBNAME test ODBC READBUFF=1000 USER=xxxxxxx PASSWORD=xxxxxxxxx DATAsrc=Ticketmaster SCHEMA=dba ;

We can see tables in the library. However when I try to open the table it opens as a blank table.

But I know there is data in that table.

What am I missing?

Regards,

Sid.

Re: SQL Anywhere data

Reeza — Fri, 21 Jun 2019 14:58:00 GMT

What happens if you try to read from a data set? Do you get an error?

data want;
set test.DATASETNAME (obs=100);

run;

@sid3284 wrote:

Hi,

We are connecting to SAP SQL anywhere database from SAS to read data.

We can create the connection through libname statement.

LIBNAME test ODBC READBUFF=1000 USER=xxxxxxx PASSWORD=xxxxxxxxx DATAsrc=Ticketmaster SCHEMA=dba ;

We can see tables in the library. However when I try to open the table it opens as a blank table.

But I know there is data in that table.

What am I missing?

Regards,

Sid.

Re: SQL Anywhere data

sid3284 — Fri, 21 Jun 2019 15:00:40 GMT

I dont get an error. But I dont see any data.

25 GOPTIONS ACCESSIBLE;
26 data want;
27 set test.tc_api_sas_manifest_Seat_export (obs=100);
28
29 run;

NOTE: There were 0 observations read from the data set TEST.tc_api_sas_manifest_Seat_export.
NOTE: The data set WORK.WANT has 0 observations and 74 variables.
NOTE: DATA statement used (Total process time):
real time 0.28 seconds
cpu time 0.08 seconds

Re: SQL Anywhere data

VDD — Fri, 21 Jun 2019 15:56:05 GMT

Did you setup a ODBC connection that defines your source?

Re: SQL Anywhere data

sid3284 — Fri, 21 Jun 2019 16:01:55 GMT

yes. Below is the odbc.ini entry.

[Ticketmaster]
Driver=/sas/sqlanywhere17/install/lib64/libdbodbc17.so
Description=SQL Anywhere 17
Host=xxxxxx
Userid=xxxxxx
DatabaseName=magic
Password=xxxxxxx

And below is the odbcinst.ini entry.

[SQLAnywhere17]
Driver = /sas/sqlanywhere17/install/lib64/libdbodbc17.so
Setup = /sas/sqlanywhere17/install/lib64/libdbodbc17.so

And below is the LD_LIBRARY_PATH entry.

export LD_LIBRARY_PATH=/usr/lib64/:/sas/sashome/SASODBCDriversfortheWebInfrastructurePlatformDataServer/9.4/Driver/:$ODBCHOME/lib64/:/sas/sqlanywhere17/install/lib64:/sas/sashome/SASFoundation/9.4/sasexe/:/sas/sashome/SASPrivateJavaRuntimeEnvironment/9.4/jre/lib/amd64/server/:/sas/sqlanywhere17/install/lib64/

Re: SQL Anywhere data

SASKiwi — Sat, 22 Jun 2019 00:43:55 GMT

I suggest you track this to SAS Tech Support if you haven't already done so. They are in the best position to diagnose what is going on here.

Re: SQL Anywhere data

Tom — Sat, 22 Jun 2019 00:45:55 GMT

I don't know anything about ANYWHERE, but in other database systems that is usually a symptom of not having the right permissions to read the data.

Re: SQL Anywhere data

SimonDawson — Sat, 22 Jun 2019 01:14:21 GMT

If I was in your shoes I'd have a look at the API trace that can be generated with sastrace. You might try use the same ODBC driver in another application (e.g. isql from unixODBC).

Re: SQL Anywhere data

sid3284 — Sat, 22 Jun 2019 02:09:35 GMT

Thanks all. Turns out that we were connecting to another database server. We connected to the correct database and we can see the data.

Re: SQL Anywhere data

SASKiwi — Sun, 23 Jun 2019 01:37:27 GMT

@sid3284 - In that case please update your post as answered.