• Programmer Guide
•  Introduction to APIs
  • solidDB® ODBC Driver
  • solidDB® JDBC Driver
  • solidDB® Application Programming Interface (SA API)
  • solidDB® Server Control API (SSC API)
  • solidDB® Server Control API (SSC API) for Java
  • solidDB® Transaction Log Reader
  •  Building client applications
    • What is a client?
    • How is the query passed to the server?
    • How are the results passed back to the client?
    • Statement cache
•  solidDB® ODBC API
  •  Getting started with solidDB® ODBC
    • Installing solidDB® ODBC Driver
    • Using the ODBC driver library
    • ODBC API basic application steps
    • Format of the solidDB® connect string
    • Client-side solid.ini configuration file
    • ODBC non-standard behavior
    • Overview of usage on Windows operating systems
  • solidDB® ODBC Driver 3.51 features support
  • Calling functions
  •  Connecting to a data source
    • Network name and connect string syntax
    • Using logical data source names
    • Empty data source name
    • Configuring the solidDB® ODBC Data Source for Windows
    • Using solidDB® ODBC Driver with unixODBC
    • Retrieving user login information
  • ODBC handle validation
  • Executing transactions
  • Retrieving information about the data source’s catalog
  •  Using ODBC extensions to SQL
    • Procedures
    • Hints
    • Additional ODBC extension functions
  • solidDB® extensions for ODBC API
  •  Using cursors
    • Assigning storage for rowsets (binding)
    • Cursor support
  • Using bookmarks
  •  Error text format
    • Processing error messages
  • Terminating transactions and connections
  • Constructing an application
  • Testing and debugging an application
•  solidDB® JDBC Driver
  •  Getting started with solidDB® JDBC Driver
    • Registering solidDB® JDBC Driver
    • Connecting to the database
  • Special notes about solidDB® and JDBC
  • JDBC driver interfaces and methods
  •  solidDB® JDBC Driver extensions
    • WebSphere compatibility
    • Connection timeout in JDBC
    • Non-standard JDBC connection properties
  •  JDBC 2.0 optional package API support
    • JDBC connection pooling
    • solidDB® Connected RowSet Class: SolidJDBCRowSet
    • Java Naming and Directory Interface (JNDI)
  • Code examples
  • solidDB® JDBC Driver type conversion matrix
•  solidDB® SA
  • What is solidDB® SA?
  • Getting started with solidDB® SA
  • Writing data by using solidDB® SA without SQL
  • Reading data by using solidDB® SA without SQL
  • Running SQL statements by using solidDB® SA
  • Transactions and autocommit mode
  • Handling database errors
  • Special notes about solidDB® SA
  •  solidDB® SA function reference
    • SaArrayFlush
    • SaArrayInsert
    • SaColSearchCreate
    • SaColSearchFree
    • SaColSearchNext
    • SaConnect
    • SaCursorAscending
    • SaCursorAtleast
    • SaCursorAtmost
    • SaCursorBegin
    • SaCursorClearConstr
    • SaCursorColData
    • SaCursorColDate
    • SaCursorColDateFormat
    • SaCursorColDfloat
    • SaCursorColDouble
    • SaCursorColDynData
    • SaCursorColDynStr
    • SaCursorColFloat
    • SaCursorColInt
    • SaCursorColLong
    • SaCursorColNullFlag
    • SaCursorColStr
    • SaCursorColTime
    • SaCursorColTimestamp
    • SaCursorCreate
    • SaCursorDelete
    • SaCursorDescending
    • SaCursorEnd
    • SaCursorEqual
    • SaCursorErrorInfo
    • SaCursorFree
    • SaCursorInsert
    • SaCursorLike
    • SaCursorNext
    • SaCursorOpen
    • SaCursorOrderbyVector
    • SaCursorPrev
    • SaCursorReSearch
    • SaCursorSearch
    • SaCursorSearchByRowid
    • SaCursorSearchReset
    • SaCursorSetLockMode
    • SaCursorSetPosition
    • SaCursorSetRowsPerMessage
    • SaCursorUpdate
    • SaDateCreate
    • SaDateFree
    • SaDateSetAsciiz
    • SaDateSetTimet
    • SaDateToAsciiz
    • SaDateToTimet
    • SaDefineChSet
    • SaDfloatCmp
    • SaDfloatDiff
    • SaDfloatOverflow
    • SaDfloatProd
    • SaDfloatQuot
    • SaDfloatSetAsciiz
    • SaDfloatSum
    • SaDfloatToAsciiz
    • SaDfloatUnderflow
    • SaDisconnect
    • SaDynDataAppend
    • SaDynDataChLen
    • SaDynDataClear
    • SaDynDataCreate
    • SaDynDataFree
    • SaDynDataGetData
    • SaDynDataGetLen
    • SaDynDataMove
    • SaDynDataMoveRef
    • SaDynStrAppend
    • SaDynStrCreate
    • SaDynStrFree
    • SaDynStrMove
    • SaErrorInfo
    • SaGlobalInit
    • SaSetDateFormat
    • SaSetSortBufSize
    • SaSetSortMaxFiles
    • SaSetTimeFormat
    • SaSetTimestampFormat
    • SaSQLExecDirect
    • SaTransBegin
    • SaTransCommit
    • SaTransRollback
    • SaUserId
•  Transaction Log Reader
  • Considerations for developing applications with Log Reader supported table types
  • Configuring the Log Reader
  • Reading log data with the Log Reader
  •  Partitioning and filtering log records
    • Creating and deleting partitions
    • Using partition filters
  • Setting transaction batches
•  Working with Unicode
  • What is Unicode?
  • Designing Unicode databases
  • Using solidDB® tools with Unicode
  •  Compatibility between Unicode and partial Unicode databases
    • Converting partial Unicode databases to Unicode
  •  Developing applications for Unicode
    • ODBC applications and Unicode databases
    • JDBC applications and Unicode databases
•  solidDB® supported ODBC functions
  • Connecting to a data source
  • Obtaining information about a driver and data source
  • Setting and retrieving descriptor fields
  • Preparing SQL requests
  • Submitting requests
  • Retrieving results and information about results
  • Obtaining information about the data source’s system tables
  • Terminating a statement
  • Terminating a connection
• solidDB® ODBC Driver 3.5.1 attributes support
•  SQLSTATE error codes
  • Error codes table convention
  • SQLSTATE codes
•  Minimum SQL grammar requirements for ODBC
  •  SQL statements
    • Control statements (logical condition)
  • Data type support
  • Parameter data types
  • Literals in ODBC
  • List of reserved keywords
•  Data types
  • SQL data type overview
  • C data types
  • Data type identifiers
  • SQL data types
  • C data types
  • Numeric literals
  • Overriding default precision and scale for numeric data types
  • Data type identifiers and descriptors
  • Decimal digits
  • Transfer octet length
  • Constraints of the Gregorian calendar
  • Converting data from SQL to C data types
  • Data conversion tables from SQL to C
  • SQL to C data conversion examples
  • Converting data from C to SQL data types
  • Data conversion tables from C to SQL
  • C to SQL data conversion examples
•  Scalar functions
  • ODBC and SQL-92 scalar functions
  • String functions
  • Numeric functions
  • Time and date functions
  • System functions
  • Explicit data type conversion
  • SQL-92 CAST function
•  Timeout controls
  • Client timeouts
  • Server timeouts
  • HotStandby timeouts
•  Client-side configuration parameters
  • Setting client-side parameters through the solid.ini configuration file
  • Client section
  • Com section
  • Data Sources section
  • SharedMemoryAccess section
  • TransparentFailover section