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

Table 10 Obtaining Information About a Data Source’s System (continued)
Description
Supported by
ODBC/MXODBC VersionFunction
Returns information about the optimal set of
columns that uniquely identifies a row in a
Yes1.0SQLSpecialColumns
specified table or the columns that are
automatically updated when any value in the row
is updated by a transaction.
Returns statistics about a single table and the list
of indexes associated with the table.
Yes1.0SQLStatistics
NOTE: See the considerations under
SQLStatistics Function.
Returns a list of tables and the privileges
associated with each table.
Yes1.0SQLTablePrivileges
Returns the list of table names stored in a specific
data source.
Yes1.0SQLTables
NOTE: See the considerations under
Unsupported ODBC API Functions and Data Types.
Table 11 Terminating a Statement
Description
Supported by
ODBC/MXODBC VersionFunction
Ends statement processing, discards pending
results; can also free all resources associated with
the statement handle.
Yes1.0SQLFreeStmt
Closes a cursor that has been opened on a
statement handle.
Yes3.xSQLCloseCursor
Closes a cursor that has been opened on a
statement handle.
Yes1.0SQLCancel
NOTE: See the considerations under SQLCancel
Function.
Commits or rolls back a transaction.Yes3.xSQLEndTran
Table 12 Terminating a Connection
Description and Notes
Supported by
ODBC/MXODBC VersionFunction
Closes the connection.Yes1.0SQLDisconnect
Releases an environment, connection, statement,
or descriptor handle.
Yes3.xSQLFreeHandle
SQL Conformance Level
ODBC/MX conforms to the SQL language entry level of SQL-92. This subsection describes the
ODBC/MX support for:
• “SQL Scalar Functions” (page 36)
• “ODBC Data Types” (page 38)
• “Microsoft Escape Clauses” (page 41)
• “Stored Procedures” (page 41)
• “Timestamp Values with Fraction” (page 42)
SQL Conformance Level 35