SQL/MX Comparison Guide for SQL/MP Users

Embedded SQL
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
4-13
Stored Procedures in Java
Stored Procedures in Java
Both NonStop SQL/MP and NonStop SQL/MX allow you to use stored procedures, with
these differences:
SQL/MP Stored Procedures
•
Only callable from ODBC/MP.
•
The called stored procedure must be a Pathway server with embedded SQL,
written in COBOL, C, or TAL.
•
Cannot use SQL/MX features like Publish/Subscribe.
SQL/MX Stored Procedures
•
Callable from any SQL/MX application: MXCS, JDBC/MX, NonStop SQLJ, MXCI,
or embedded SQL(MX) within a COBOL or C/C++ program.
•
The called stored procedure must be written in Java.
•
Implementation closely follows ANSI standards (SQL99 and SQL/JRT).
For more details on SQL/MX stored procedures, see the SQL/MX Guide to Stored
Procedures in Java.
Similarity Checks and Automatic
Recompilation
NonStop SQL/MX and SQL/MP perform similarity checking in different ways. These
are differences between the products:
Difference between compile and run
time module
Does SQL/MP
similarity check pass?
Does SQL/MX
similarity check pass?
Name of table Yes Yes
Data in the table Yes Yes
Number of partitions Yes for serial plans
No for parallel plans
No, unless plan
chooses online
transaction optimization
Partition key ranges Yes for serial plans
No for parallel plans
Yes
Non-partitioned table at compile time
is partitioned at run time
Yes No, unless plan
chooses online
transaction optimization
ESP Parallelism used in the plan No No