Introduction
What Is Rogue Wave DB Link?
Supported RDBMSs and Platforms
About this manual
What You Need to Know
Manual Organization
Notation
Where to Get More Information
Data Types
Output Mode
DB2
Informix
MS SQL Server
ODBC
Oracle
Sybase
Special Features
Input Mode
Date As String
Numeric As String
MS SQL Server Limitation
Configuration Issues
Environment Variables
DB2
Informix
MS SQL Server
Oracle
Globalization
Concepts
Implementation
Usage
Resources
Configuration Features
Date As String
Numeric As String
Numeric As Object
Array Bind
Array Fetch
Asynchronous Processing Mode
Principle
Important Behavior Change
Drivers that Support Asynchronous Processing
Functions that Use Asynchronous Processing
Server Information
Sessions & Connections
Connection Handling through IldDbms Objects
Initiating a Session or a Connection
Creating IldDbms Objects
Session Configuration
Disconnecting and Reconnecting
Number of Connections
Destroying IldDbms Objects
Accessing the Database Schema
Schema Entity Types
Schema Entity Names and Owners
Tables and Views
Procedures and Functions
Synonyms
Abstract Data Types
Table Privileges
Data Definition Language (DDL)
Transaction Control
Initiating a Transaction
Committing a Transaction
Rolling Back a Transaction
Autocommit Mode
Cursor Allocation
Extending the IldDbms Class
Use Notification
Subscribe to an Event
Unsubscribe from an Event
Differences between IldDbms and IldDbmsModel Classes
Cursors
IldRequest Objects
Creating IldRequest Objects
Number of Active Cursors
Disposing of IldRequest Objects
Configuration Settings
Default Settings
Accessing and Changing the Configuration
Array Modes
Column and Parameter Descriptors
Notion of Descriptors
Implementation Descriptors
Application Descriptors
Processing SQL Statements
Immediate Execution
Deferred Execution
Results Retrieval
Handling Multiple Result Sets
Direct Access
Binding to User-Allocated Memory
Binding Input Variables
Standard Implementation
The following code extract is taken from the sample file sybproc.cpp and shows how this argument is used:
Overloaded Version
Setting Parameter Values
Specific Considerations
Generic Data Types
Handling Date and Time Values
Handling Exact Numeric Values
Large Objects (LOBs)
Sending Large Objects
Different Ways of Retrieving Large Objects
Handling Abstract Data Type Values
Abstract Data Type Descriptor
Abstract Data Type Values
Extending the IldRequest Class
Differences between IldRequest and IldRequestModel Classes
Queries
Executing an SQL Query Immediately
Setting Up a Query for Multiple or Repeated Use
Binding Application Memory to the Database API
Finding Out the Types and Sizes of Returned Columns
Retrieving Data
Errors and Warnings
Diagnostic Class
Accessing a Diagnostic Instance
Context Information
Warnings
Errors
Error Handlers
Error Codes
Rogue Wave DB Link API Codes and Messages Table
Function Codes
SQLSTATE
Error Messages
Error Origin
Erroneous IldDbms and IldRequest Objects
Error Reporter
Default Settings and Behavior
Output Error Stream
Customizing the Error Handling Mechanism
Base Class
Virtual Functions and Their Parameters
Compiling and Linking
Compilation Flags
Compatibility with Previous Releases
RDBMS Flags
Dynamic Load
Mode and Flag
Target RDBMSs
Multiple Targets
RDBMS Prerequisites
Rogue Wave DB Link Libraries
Library Names
Building Dynamically-Loadable Drivers under UNIX
Code Samples
Generic Examples
Basic Use
Handling Dates and Numbers
SQL Interpreter
Concurrent Connections and Cursors
Relation Searching
Relation Names
Input Bindings
Output Bindings
Multiple Output Bindings
Handling LOBs
Asynchronous Processing
RDBMS-Specific Examples
Informix
Oracle
Sybase
Introduction
Sybase