Working with Native Database Interfaces

Table of Contents

Using Native Database Interfaces
About native database interfaces
Components of a database interface connection
Using a native database interface
Using Adaptive Server Enterprise
Supported versions for Adaptive Server
Supported Adaptive Server datatypes
Basic software components for Adaptive Server
Preparing to use the Adaptive Server database
Defining the Adaptive Server database interface
Using Open Client security services
Using Open Client directory services
Using PRINT statements in Adaptive Server stored procedures
Creating a DataWindow object based on a cross-database join
Installing stored procedures in Adaptive Server databases
Using Informix
Supported versions for Informix
Supported Informix datatypes
Features supported by the I10 interface
Basic software components for Informix
Preparing to use the Informix database
Defining the Informix database interface
Accessing serial values in a PowerBuilder script
Using Microsoft SQL Server
Supported versions for SQL Server
Supported SQL Server datatypes
Basic software components for Microsoft SQL Server
Preparing to use the SQL Server database
Defining the SQL Server database interface
Migrating from the MSS or OLE DB database interfaces
SQL Server 2008 features
Notes on using the MSOLEDBSQL and SNC interfaces
Connection difference between MSOLEDBSQL 18.x and 19
Using Oracle
Supported versions for Oracle
Supported Oracle datatypes
Basic software components for Oracle
Preparing to use the Oracle database
Defining the Oracle database interface
Using Oracle stored procedures as a data source
Using Oracle user-defined types
Support for HA event notification
ORA driver support for Oracle 11g features
Using DirectConnect
Using the DirectConnect interface
Supported versions for the DirectConnect interface
Supported DirectConnect interface datatypes
Basic software components for the DirectConnect interface
Preparing to use the database with DirectConnect
Defining the DirectConnect interface
Creating the extended attribute system tables in DB2 databases

This part describes how to set up and define database connections accessed through one of the native database interfaces.