Overview
Understanding OpenAccess SDK
Choosing a Configuration
OpenAccess SDK IP Development Kit
Overview of the Third-party SQL Engine API
Developing an IP Using C/C++
Developing an IP Using Java
Mapping ODBC Calls to Third-party SQL Engine API Calls
IP API Reference for C/C++
Overview
IP API for C/C++
OASQLIP_alloc_connect
OASQLIP_alloc_stmt
OASQLIP_cancel
OASQLIP_catalogs
OASQLIP_close_cursor
OASQLIP_close_stmt
OASQLIP_columns
OASQLIP_commit
OASQLIP_connect
OASQLIP_disconnect
OASQLIP_error
OASQLIP_execute_direct_stmt
OASQLIP_execute_stmt
OASQLIP_exit
OASQLIP_fetch_row
OASQLIP_foreignkeys
OASQLIP_free_colval
OASQLIP_free_connect
OASQLIP_free_stmt
OASQLIP_get_colattr
OASQLIP_get_colspec
OASQLIP_get_colval
OASQLIP_get_connect_info
OASQLIP_get_ds_info
OASQLIP_get_numcols
OASQLIP_get_numparams
OASQLIP_get_paramspec
OASQLIP_get_stmt_info
OASQLIP_init
OASQLIP_init_param
OASQLIP_open_next_cursor
OASQLIP_open_output_cursor
OASQLIP_prepare_stmt
OASQLIP_prepare_to_commit
OASQLIP_primarykeys
OASQLIP_procedurecolumns
OASQLIP_procedures
OASQLIP_rollback
OASQLIP_schemas
OASQLIP_set_connect_info
OASQLIP_set_stmt_info
OASQLIP_specialcolumns
OASQLIP_start_transaction
OASQLIP_statistics
OASQLIP_tables
OASQLIP_tabletypes
OASQLIP_types
sqlu_addToDataChain
sqlu_createDataChain
sqlu_freeDataChainList
sqlu_freeDataChainListUTF16
sqlu_getDataChainListUTF16
Returning Values for Long Data Types
Sample Code
Trace Function: tm_trace
tm_trace
IP API Reference for Java
Overview
Local Configuration
Client/Server Configuration
IP API Interfaces for Java
oajava.sql.sqlip Interface
oajava.sql.sqlip_stmt Interface
Connection-level Methods for Java
sqlipCommit
sqlipConnect
sqlipDisconnect
sqlipError
sqlipGetDsInfo
sqlipGetInfo
sqlipRollback
sqlipSetInfo
sqlipStartTransaction
Statement-level Methods for Java
sqlipBestRowIdentifier
sqlipCatalogs
sqlipCloseCursor
sqlipCloseStmt
sqlipColumns
sqlipDeclareCursor
sqlipError
sqlipExecuteStmt
sqlipFetchRow
sqlipFetchRowsInBuffer
sqlipForeignKeys
sqlipGetColattr
sqlipGetColspec
sqlipGetColval
sqlipGetInfo
sqlipGetNumcols
sqlipGetNumParams
sqlipGetParamspec
sqlipIndexInfo
sqlipInitParam
sqlipOpenNextCursor
sqlipMapToXoType
sqlipOpenOutputCursor
sqlipPrepareStmt
sqlipPrepareToCommit
sqlipPrimaryKeys
sqlipProcedures
sqlipProcedureColumns
sqlipSchemas
sqlipSetInfo
sqlipTables
sqlipTableTypes
sqlipTypeInfo
sqlipVersionColumns
Schema Management
Implementing Schema Objects in C/C++
Pattern Value Arguments
Implementing Schema Objects in Java
Schema Objects
Columns Catalog Table: OA_COLUMNS
Specifying Data Types of Columns
Index Catalog Table: OA_STATISTICS
Foreign Keys Catalog Table: OA_FKEYS
Procedures Catalog Table: OA_PROC
Procedures Columns Table: OA_PROCCOLUMNS
Tables Catalog Table: OA_TABLES
Types Table: OA_TYPES
Setting Up Your Development Environment in C/C++
Requirements for Link Edit and Compiling an IP
Setting Up the IP Source
Setting Up an OpenAccess SDK Service and Data Source
Connecting to Your Data Source
Setting Up Your Development Environment for Java
Requirements for Link Edit and Compiling an IP
Setting Up an IP Source and Schema
Setting Up an OpenAccess SDK Service and Data Source
Connecting to Your Data Source
Setting Up the oaodbc Sample
Setting Up oaodbc on Windows
Setting Up a Sample on Linux/UNIX
Setting Up the oajava Sample
Setting up the oajava sample on Linux/UNIX/Windows
Tuning the oajava sample
Overview
Tuning the oajava sample