•  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