Sybase wrapper support for Adaptive Server Enterprise (ASE)

The Sybase wrapper supports the SAP Adaptive Server Enterprise (ASE) 16.0, in addition to ASE 15.5 and ASE 15.7.

Supported clients for SAP ASE 15.x and 16.0
You can connect to the ASE 15.x and 16.0 by using the Sybase wrapper with the Sybase client, version 15.0 or later.
If you use SDK, version 15.0 as a Sybase client, IBM recommends that you to install the ESD #3 or later. If you do not install the ESD, you might get an unexpected error while using the Sybase wrapper.
Updating Sybase libraries for the Sybase client, version 15.0
UNIX: If you use the Sybase client, version 15.0, you can run the Sybase lnsyblibs script to update Sybase library names to preserve consistency among supported versions of Sybase library files. The lnsyblibs script creates symbolic links from the new library names to the old library names, which allows the pre-version 15.0 applications to work with renamed libraries.
Windows: If you use the Sybase client, version 15.0 you can run the copylibs.bat file to copy the required *.dll files, which allows the pre-version 15.0 applications to work with renamed libraries.
lnsyblibs script error
The current lnsyblibs script contains an problem. When you run 'lnsyblibs create', the following error message occurs:
"libsyb*.s[o: No such file or directory"
As a workaround to this problem, you can delete the | (bar character) within [] (square brackets) at line 34 of the script. Sybase is aware of this problem.
Support for merge joins
Sybase merge joins are not enabled by default. You must enable merge joins on both your Sybase server and the federated server before you can use merge joins with Sybase ASE data sources:
  1. Enable merge joins on your Sybase server, see Sybase infocenter.
  2. Run the ALTER SERVER statement to enable merge joins on your federated server:
    ALTER SERVER sybase_server OPTIONS (ADD DB2_merge_join 'Y');
    where sybase_server is the name of your Sybase server.