Open System Services ODBC/MX Client Driver (SQL/MX 2.x)

ODBC/MX Conformance
HP NonStop Open System Services ODBC/MX Client Driver—544990-002
3-14
Stored Procedures
Stored Procedures
ODBC/MX supports stored procedures, with the following exceptions:
•
ODBC/MP stored procedures cannot be converted to ODBC/MX procedures. They
must be rewritten.
•
Results sets, pointers to cursors, and returning codes are not supported.
For more information about stored procedures, see the SQL/MX Guide to Stored
Procedures in Java.
Transactions and Cursor Behavior with Multiple Statements
Table 3-19. Transactions and Cursor Behavior
Autocommit SQL/MX Behavior Action Required
ON When any open statement reaches
end of data or end of cursor,
SQL/MX closes all other open
statements.
N.A.
OFF N.A. The application must explicitly
rollback or commit the transaction.
All open statements are closed at
that time.