• Print |
• E-mail  |
• Bookmark

The SAS/Access Interface to Sybase is not supported when running against
ASIQ 12.x.  This is because of the limitations of the ASIQ 12.x API.

You can use the SAS/Access Interface to ODBC for certain functionalities
of ASIQ 12.  With the current release of ASIQ 12, you cannot update
data at all (DATA step modify, PROC SQL LIBNAME update, SCL code doing
updates, or even simple Passthrough Update statement will not work).
As of ASIQ 12.4.1, GA in May, the PROC SQL Pass-Through Facility will
work using the EXECUTE (UPDATE ...) statement.  However, updating using
a cursor (which is what is used with DATA step modify and PROC SQL
LIBNAME update) is not scheduled to be supported by the ODBC driver.
Also, ASIQ does not support bulk loading, so we recommend using the
DBISQL "load" statement to load data from an external sequential file.

In order to use SAS/Access Interface to ODBC, certain restrictions and
setup information is required.  ASIQ 12.x supports ODBC 3.x.  You must
do a FULL install of ASIQ 12.x on the client machine (Sybase does not
have a client install yet).   The following is an example of the entry
in the odbc.ini file:

          SybaseIQ=Sybase IQ ODBC driver

          [SybaseIQ]
          Driver=/dbi/sybase/odbc/12.4.0_P/products/asiq/lib/dbodbc6.so
          Description=SybaseIQ
          Userid=dba
          Password=sql
          EngineName=asiq12
          CommLinks=tcpip(host=10.26.10.24;port=2638)
          AutoStop=no
          AutoPreCommit=yes
          DatabaseName=asiqusers
          DatabaseFile=D:\Sybase\iq12\users.db


If the ASIQ server is on a remote NT node then you must specify
DatabaseFile= and host=, as shown above using the ip address instead of
the host name.  Also, AutoPreCommit=yes MUST be set.

Operating System and Release Information