Show TOC

Function documentationSQLDBC Classes Locate this document in the navigation structure

 

SQLDBC Classes

Name

Description

SQLDBC::SQLDBC_Environment

Base class of the SQLDBC library

You can use the methods of this class to:

  • Create and release SQLDBC_Connection objects

  • Control SQLDBC traces

  • Control runtime behavior (single- and multi-threading, memory management)

  • Query SQLDBC properties such as the SQLDBC version

SQLDBC::SQLDBC_Connection

Management of database connections

You can use the methods of this class to:

  • Open database sessions

  • Control transactions

  • Change date and time formats of database sessions

  • Information about a database session, such as the database version

  • Create objects with which SQL statements can be executed

SQLDBC::SQLDBC_ConnectProperties

Using the methods of this class, together with a SQLDBC_Connection object, you can assign the following special properties, among others, to a database session or query these properties:

  • Session: SQL mode, timeout, isolation level

  • Performance: select-fetch optimization, SQL statement cache

  • Compatibility: cursor prefix, filling procedure for columns with alphanumeric values (blank padding)

  • Rounding behavior: setting defining whether numbers are truncated or rounded

  • Handling of superfluous spaces

SQLDBC::SQLDBC_Statement

You can use the methods of this class to execute SQL statements without parameters, such as DDL statements.

Recommendation Recommendation

Execute all SQL statements without parameters using the methods of this class.

End of the recommendation.

You can use the methods of this class to:

  • Generate results sets (write-protected or changeable)

  • Combine SQL statements into group requests

  • Query information about result sets such as the number of changed table rows

  • Query sequence numbers (serials) of INSERT statements

SQLDBC::SQLDBC_PreparedStatement

This class is derived from the SQLDBC_Statement class. You can use the methods of this class to execute SQL statements with parameters. You enter parameters in SQL statements with ? or :<identifier> (see the SQL Reference Manual, Parameter Name (parameter_name)).

You can use the methods of this class to:

  • Bind parameters to program variables (necessary before executing SQL statements with parameters)

  • Parse SQL statements

  • Query information about parameters

  • Execute mass requests (batch or array statements)

SQLDBC::SQLDBC_ParameterMetaData

You can use the methods of this class to query data type and length information for parameters in SQL statements.

SQLDBC::SQLDBC_ResultSetMetaData

You can use the methods of this class to query data type and length information for columns in result sets of SQL statements.

SQLDBC::SQLDBC_ResultSet

Processing of result sets that were generated by executing SQL statements with the methods of the class SQLDBC_Statement or the class SQLDBC_PreparedStatement

You can use the methods of this class to:

  • Navigate result sets

  • Generate excerpts (row sets) from result sets

  • Bind program variables for reading the column values of result sets

  • Execute block operations for reading part (see SQLDBC_RowSet class) or all of the result set

SQLDBC::SQLDBC_RowSet

Reading of data from result sets

Row sets are excerpts from result sets that were generated with methods of the SQLDBC_ResultSet class.

You can use the methods of this class to:

  • Address individual rows within the row set

  • Transfer individual column contents into program variables

  • Use block operations to transfer column contents into arrays of program variables

SQLDBC::SQLDBC_UpdatableRowSet

This class is derived from the SQLDBC_RowSet class and contains methods for changeable result sets.

You can use the methods of this class to:

  • Change the contents of columns (UPDATE)

  • Delete table rows (DELETE)

  • Add new table rows (INSERT)

SQLDBC::SQLDBC_LOB

Processing of column values from LOB columns

You can use the methods of this class to read and write LOB values piece-wise.

SQLDBC::SQLDBC_ErrorHndl

You can use the methods of this class to query the error messages of previous operations.

SQLDBC::SQLDBC_SQLWarning

You can use the methods of this class to query the warnings of previous operations.

More Information

SQL Reference Manual

SQL Tutorial