Database interface

Functionality

New Sybase SYJ database interface

Provides connectivity to Sybase Adaptive Server Enterprise 11.5 for a PowerBuilder custom class user object deployed as a Jaguar component

Using the SYJ interface  Sybase's Jaguar CTS uses a slightly different version of the CT-Lib software. Therefore, at runtime, you need to use the SYJ database interface rather than SYC to connect to a 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 Jaguar), you must use SYC to connect to the database.

New JDS and JDM JDBC database interface

Provides connectivity to databases that comply with the JDBC API

New OLE DB database interface

Provides connectivity to databases that comply with the new OLE DB API. OLE DB provides an architecture for accessing all types of data — both SQL and non-SQL — by componentizing database and related data processing functionality

INTERSOLV OLE DB data providers are supplied with PowerBuilder

The initial release of the OLE DB interface will be supported on Windows only

Enhanced Sybase SYC database interface

Provides support for new functionality in Sybase Adaptive Server Enterprise 11.5 including the ability to create and use extended stored procedures as well as to create a DataWindow object based on a heterogeneous cross-database join

Enhanced Sybase DIR database interface

Provides support for a DirectConnect Transaction Router Service (TRS) connection to a DB2/MVS database