Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 9 Retrieving Results and Information About Results
Description
Supported by
ODBC/MXODBC VersionFunction
Returns the number of rows affected by an insert,
update, or delete request.
Yes1.0SQLRowCount
Returns the number of columns in the result set.Yes1.0SQLNumResultCols
Describes a column in the result set.Yes1.0SQLDescribeCol
Describes the attributes of a column in a result
set.
Yes1.0SQLColAttribute
Assigns storage for a result column and specifies
the data type.
Yes1.0SQLBindCol
Returns multiple result rows.Yes1.0SQLFetch
Supported for SQL_FETCH_NEXT attribute only.Yes3.xSQLFetchScroll
Returns scrollable result rows.
Returns part or all of one column of one row of
a result set (useful for long data values).
Yes1.0SQLGetData
Fetches the specified rowset of data from the
result set and returns data for all bound columns.
No bookmarks are supported.
Yes1.0SQLExtendedFetch
Positions a cursor within a fetched block of data
and allows an application to refresh data in the
Yes1.0SQLSetPos
row set or to update or delete data in the result
set.
Determines whether there are more result sets
available and, if so, initializes processing for the
next result set.
Yes1.0SQLMoreResults
Returns additional diagnostic information (a single
field of the diagnostic data structure).
Yes3.xSQLGetDiagField
Returns additional diagnostic information (multiple
fields of the diagnostic data structure).
Yes3.xSQLGetDiagRec
Table 10 Obtaining Information About a Data Source’s System
Description
Supported by
ODBC/MXODBC VersionFunction
Returns the list of procedure names stored in a
specific data source.
Yes1.0SQLColumnPrivileges
Yes1.0SQLColumns
Yes1.0SQLForeignKeys
Returns a list of column names that make up the
primary key for a table.
Yes1.0SQLPrimaryKeys
See the discussion of SQLPrimaryKeys in
SQLPrimaryKeys Function.
Returns the list of input and output parameters, as
well as the columns that make up the result set for
the specified procedures.
Yes1.0SQLProcedureColumns
Returns the list of procedure names stored in a
specific data source.
Yes1.0SQLProcedures
34 ODBC/MX Conformance