Using the SYJ database interface

EAServer uses a slightly different version of the Sybase Open Client CT-Library (CT-Lib) software from PowerBuilder. Therefore, at runtime, you need to use SYJ rather than ASE or SYC to connect to an Adaptive Server Enterprise database. The SYJ Database Profile Setup dialog box provides a convenient way to set the appropriate connection parameters and then copy the syntax from the Preview tab into the script for your Transaction object.

You cannot use the SYJ interface, however, to connect to the database in the PowerBuilder development environment. Therefore, during the development phase (before the component has been deployed to EAServer), you must use ASE or SYC to connect to the database.

Note that the SYJ database interface supports only those DBParms relevant at runtime. It does not support any DBParm parameters that have to be set before PowerBuilder establishes a database connection. The following DBParms, which are included on the SYJ Profile Setup dialog box, are not supported by SYJ: