Open System Services ODBC/MX Client Driver Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table 5 Setting and Retrieving Driver Attributes (continued)
Description
Supported by
ODBC/MXODBC VersionFunction
Sets a statement attribute.Yes3.xSQLSetStmtAttr
Note: See the considerations under
SQL_QUERY_TIMEOUT Option
Returns the value of a statement attribute.Yes3.xSQLGetStmtAttr
Table 6 Setting and Retrieving Descriptor Fields
Description
Supported by
ODBC/MXODBC VersionFunction
Prepares an SQL statement for later execution.Yes1.0SQLSetDescField
Assigns storage for a parameter in an SQL
statement.
Yes2.0SQLBindParameter
Returns the cursor name associated with a statement
handle.
Yes1.0SQLGetCursorName
Specifies a cursor name.Yes1.0SQLSetCursorName
Sets the option that controls cursor behavior.No1.0SQLSetScrollOption
Table 7 Preparing SQL Requests
Description
Supported by
ODBC/MXODBC VersionFunction
Prepares an SQL statement for later execution.Yes1.0SQLPrepare
Assigns storage for a parameter in an SQL
statement.
Yes2.0SQLBindParameter
Returns the cursor name associated with a
statement handle.
Yes1.0SQLGetCursorName
Specifies a cursor name.Yes1.0SQLSetCursorName
Sets the option that controls cursor behavior.Yes1.0SQLSetScrollOption
Table 8 Submitting SQL Requests
Description
Supported by
ODBC/MXODBC VersionFunction
Executes a prepared statement.Yes1.0SQLExecute
Executes a statement.Yes1.0SQLExecDirect
Returns the text of an SQL statement as translated
by the driver.
Yes1.0SQLNativeSql
Returns the description for a specific parameter in
a statement.
Yes1.0SQLDescribeParam
Returns the number of parameters in a statement.Yes1.0SQLNumParams
Used with SQLPutData to supply parameter data
at execution time (useful for long data values).
Yes1.0SQLParamData
Sends part or all of a data value for a parameter
(useful for long data values).
Yes1.0SQLPutData
NOTE: See the considerations under SQLPutData.
ODBC API Functions 33










