Returns the number of rows affected by an UPDATE, INSERT, or DELETE statement.

Version introduced: 1.0

Availability when using ODBC: Supported

Conformance: ISO 92

Returns the number of columns in a result set.

Version introduced: 1.0

Availability when using ODBC: Supported

Conformance: ISO 92

Returns the result descriptor (column name, type, column size, decimal digits, and nullability) for one column in the result set. This information is also available in the fields of the IRD.

The driver now returns the number of characters instead of the number of bytes for the following attributes: SQL_DESC_LABEL, SQL_DESC_NAME, SQL_DESC_SCHEMA_NAME, SQL_DESC_CATALOG_NAME, SQL_DESC_BASE_COLUMN_NAME, and SQLDESC_BASE_TABLE_NAME

This conforms more closely to the ODBC standard and works correctly using ADO, VB, OLE-DB, and ODBC calls. Note, however, that this causes failure of the Microsoft Visual DataBase Project. After updating/inserting the record, the record is not saved and the following error is displayed: “the table does not exist”.

Version introduced: 1.0

Availability when using ODBC: Supported.

Conformance: ISO 92

N/A

Version introduced: 1.0

Availability when using ODBC: Deprecated (replaced by SQLColAttribute)

Conformance: N/A

Describes attributes of a column in the result set.

The driver now returns the number of characters instead of the number of bytes for the following attributes: SQL_DESC_LABEL, SQL_DESC_NAME, SQL_DESC_SCHEMA_NAME, SQL_DESC_CATALOG_NAME, SQL_DESC_BASE_COLUMN_NAME, and SQLDESC_BASE_TABLE_NAME

This conforms more closely to the ODBC standard and works correctly using ADO, VB, OLE-DB, and ODBC calls. Note, however, that this causes failure of the Microsoft Visual DataBase Project. After updating/inserting the record, the record is not saved and the following error is displayed: “the table does not exist.”

Version introduced: 3.0

Availability when using ODBC: Supported.

Conformance: ISO 92

Assigns storage for a result column and specifies the data type.

Version introduced: 1.0

Availability when using ODBC: Supported

Conformance: ISO 92

Returns multiple result rows, fetching the next rowset of data from the result set and returning data for all bound columns.

Version introduced: 1.0

Availability when using ODBC: Supported

Conformance: ISO 92

N/A

Version introduced: 2.0

Availability when using ODBC: Replaced by SQLFetchScroll

Conformance: N/A

Returns scrollable result rows, fetching the specified rowset of data from the result set and returning data for all bound columns. Block cursor support enables an application to fetch more than one row with a single fetch into the application buffer.

When working with an ODBC 2.x driver, the Driver Manager maps this function to SQLExtendedFetch.

Version introduced: 3.0

Availability when using ODBC: Supported

Since the solidDB^® ODBC Driver currently has no support for bookmarks, it is not possible to support the SQL_FETCH_BOOKMARK option in SQLFetchScroll.

Conformance: ISO 92

Returns part or all of one column of one row of a result set. It can be called multiple times to retrieve variable length data in parts, making it useful for long data values.

Version introduced: 1.0

Availability when using ODBC: Supported

Conformance: ISO 92

Positions a cursor within a fetched block of data and allows an application to refresh data in the rowset or to update or delete data in the result set.

Version introduced: 1.0

Availability when using ODBC: Supported, along with all the options, that is, SQL_POSITION, SQL_DELETE, and SQL_UPDATE

Conformance: ODBC

Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.

Version introduced: 3.0

Availability when using ODBC: solidDB^® supports this, but only when using the SQL_ADD option.

Conformance: ODBC

Determines whether there are more results available on a statement containing SELECT, UPDATE, INSERT, or DELETE statement and, if so, initializes processing for those results.

Version introduced: 1.0

Availability when using ODBC: Not supported

solidDB^® does not support multiple results.

Conformance: ODBC

Returns additional diagnostic information (a single field of the diagnostic data structure associated with a specified handle). This information includes error, warning, and status information.

Version introduced: 3.0

Availability when using ODBC: Supported

Conformance: ISO 92

Returns additional diagnostic information (multiple fields of the diagnostic data structure). Unlike SQLGetDiagField, which returns one diagnostic field per call, SQLGetDiagRec returns several commonly used fields of a diagnostic record, including the SQLSTATE, the native error code, and the diagnostic message text.

Version introduced: 3.0

Availability when using ODBC: Supported

Conformance: ISO 92

N/A

Version introduced: 1.0

Availability when using ODBC: Deprecated (replaced by SQLGetDiagRec)

Conformance: N/A