MX 2.x)

ODBC/MX Conformance

HP NonStop ODBC/MX Driver for Windows—527888-004

5-14

Stored Procedures

A stored procedure is a type of user-defined routine (UDR) that operates within a

database server and typically performs SQL operations on a database. ODBC/MX

supports stored procedures, with the following exceptions:

•

ODBC/MP does not support Result sets for stored procedures in java and

therefore cannot be converted to ODBC/MX procedures. They must be rewritten.

•

Returning codes are not supported.

ODBC/MX supports Stored procedures that return Result Sets and also supports

pointers to cursors on systems running J06.05 or later J-series RVUs and H06.16 and

later H-series RVUs.

For more information about stored procedures, see the SQL/MX Guide to Stored

Procedures in Java.

Transactions and Cursor Behavior with Multiple Statements

{ escape 'escape-character' } Not supported in the current release.

{ [?=]call

procedure-name... }

Not supported in the current release.

1. ODBC syntax does not include nested joins, while SQL/MX does. ODBC/MX extends the Microsoft syntax for

an outer join.

2. Functions are controlled by SQLGetInfo. Only SQL/MX native functions are supported.

Table 5-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.

Table 5-18. Microsoft Escape Clauses (continued)

Microsoft Escape Clause SQL/MX Equivalent