topic Re: Using libname from linux in SAS Programming

Using libname from linux

Jose6 — Thu, 24 Oct 2019 16:05:18 GMT

Hi experts,

when i assign a library in SAS environment EG, there's no problem using this syntax :

libname NAMEXXX SYBASEIQ DATABASE=PRODT SERVER=XXPROD PORT=9999 HOST=XXXPROD SCHEMA=DBO
USER=XXXXXXX07 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;

But when i try to use it in linux invironment (executing a sas program from linux) example:

[user@promt]$ /sas94/sashome/SASFoundation/9.4/sasexe/sas /sasxxx/temp/L1.sas

I get this error :

ERROR: Could not load /sas94/sashome/SASFoundation/9.4/sasexe/sassiq (33 images loaded)
ERROR: libdbodbc16.so: cannot open shared object file: No such file or directory
1 libname NAMEXXX SYBASEIQ DATABASE=PRODT SERVER=XXXXX_PROD PORT=9999 HOST=XXXXXXPROD SCHEMA=DBO
1 ! USER=XXXXXXX07 PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;
ERROR: The SAS/ACCESS Interface to SAPIQ cannot be loaded. The SASSIQ code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
ERROR: Errors printed on page 1.

This only happens when the library has a conections with the database sybaseiq.

when i assign a library like this libname namelib base "/sasxxx/folder"; it works fine

Re: Using libname from linux

Tom — Thu, 24 Oct 2019 16:22:34 GMT

Looks like the SYBASEIQ engine is not properly installed on that version of SAS.

Check with your local support team.

Re: Using libname from linux

SASKiwi — Thu, 24 Oct 2019 19:15:10 GMT

Since you running metadata-enabled SAS servers - you have to be to be using EG - I would expect that you would run SAS batch jobs from your configured SAS batch server directory to ensure you pick up the correct SAS configurations. In Windows it looks like this:

\SAS\Config\Lev1\SASApp\BatchServer\sasbatch.bat

But it is probably something similar on linux with forward slashes.

Re: Using libname from linux

Jose6 — Thu, 24 Oct 2019 22:10:50 GMT

Thks Guys, i guess the problem is refer to :

This is caused by the Linux loader not loading a dependency of the major version number that differs from the version number at load time.

To work around this issue, use Sybase IQ version 15.4.

Re: Using libname from linux

Jose6 — Tue, 12 Nov 2019 20:40:29 GMT

Hi Guys i got this solution:

To work-around this error you can create a soft link in the same directory as the libdbodbc16.so file.

ln -s libdbodbc16.so libdbodbc12.so

should result in :

libdbodbc12.so -> ./libdbodbc16.so

and then the Sybase IQ should work as expected.

And don´t forget to check the library path !