Working with Native Database Interfaces

This part describes how to set up and define database connections accessed through one of the 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
What are Open Client security services?
Requirements for using Open Client security services
Security services DBParm parameters
Using Open Client directory services
What are Open Client directory services?
Requirements for using Open Client directory services
Specifying the server name with Open Client directory services
Directory services DBParm parameters
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
What are the PowerBuilder stored procedure scripts?
How to run the scripts
Using Informix
Supported versions for Informix
Supported Informix datatypes
Informix DateTime datatype
Informix Time datatype
Informix Interval datatype
Features supported by the I10 interface
Accessing Unicode data
Assigning an owner to the PowerBuilder catalog tables
Support for long object names
Renaming an index
SQL statement caching
Creating and dropping indexes without locking
Column-level encryption
Using multiple OUT parameters in user-defined routines
Basic software components for Informix
Preparing to use the Informix database
Defining the Informix database interface
Specifying the server name
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
New database parameters
Support for new datatypes in SQL Server 2008
T-SQL enhancements
Unsupported SQL Server 2008 features
Notes on using the SNC interface
Using Oracle
Supported versions for Oracle
Supported Oracle datatypes
Datatype conversion
Basic software components for Oracle
Preparing to use the Oracle database
Defining the Oracle database interface
Specifying the Oracle server connect descriptor
Using Oracle stored procedures as a data source
What is an Oracle stored procedure?
What you can do with Oracle stored procedures
Using Oracle stored procedures with result sets
Using a large-object output parameter
RPC calls to stored procedures with array parameters
Using Oracle user-defined types
Support for HA event notification
ORA driver support for Oracle 11g features
Using DirectConnect
Using the DirectConnect interface
Connecting through the DirectConnect middleware product
Connecting through the Open ServerConnect middleware product
Selecting the type of connection
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
Creating the extended attribute system tables
Using the DB2SYSPB.SQL script