SQL adaptation guide For Sybase ASE 15.5+ / Installation (Runtime Configuration) |
Sybase ASE version | Shared library environment setting |
---|---|
Sybase ASE 15.5 and higher | UNIX: Add $SYBASE/ OCSDIR /lib to LD_LIBRARY_PATH (or its equivalent). Windows: Add %SYBASE%\ OCSDIR \dll to PATH. Where OCSDIR is the directory of the Sybase Open Client Software.For example, with Sybase 15.5, this directory is named OCS-15_0. |
When connecting from a Genero program, both database and server names can be specified with:
database@server
For more details see the description for the connection data source parameter in DATABASE and CONNECT instructions.
The Sybase client locale must match the locale used by the runtime system (LC_ALL,LANG on UNIX, ANSI code page on Windows).
By default, Sybase OCS uses the character set defined by the operating system. On Windows, this is the ANSI code page, on UNIX it is defined by LC_CTYPE, LC_ALL or LANG environment variables. Note that Genero BDL allows to define the LANG environment variable also on Windows. The value of the LANG environment variable must be listed in the locales.dat file under the $SYBASE/locales directory, otherwise you will get an error when connecting to the database.
See also Sybase OCS documentation regarding localization and character set definition.
$ isql -S server -U appadmin -P password
dbi.database.dbname.ase.logintime = integer
This entry defines the number of seconds to wait for a connection.
Default is 5 seconds.
dbi.database.dbname.ase.prefetch.rows = integer
Default is 10 rows.