SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

About This Manual

HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004

Examples in This Manual

The examples and sample SPJs in this manual refer to the SQL/MX sample database.

To install the sample database, see the SQL/MX Quick Start. For information about the

schema and tables of the sample database, see the SQL/MX Reference Manual.

Most of the examples and sample SPJs can query both SQL/MP and SQL/MX tables

of the SQL/MX sample database. To query SQL/MP tables, use the NonStop SQL/MX

Release 1.8 sample database. To query SQL/MX tables, use the NonStop SQL/MX

Release 2.x sample database.

For the entire set of sample SPJs, see Appendix A, Sample SPJs.

Section 6, Managing SPJs in NonStop

SQL/MX

Describes management tasks related to SPJs,

such as granting privileges for invoking SPJs,

showing the SPJs that exist in a database, and

using SPJs in a distributed database

environment.

Section 7, Performance and

Troubleshooting

Describes how to improve and monitor the

performance of SPJs and provides guidelines for

troubleshooting common problems.

Appendix A, Sample SPJs

Provides SPJ methods that demonstrate

business logic in an SQL/MX database.

Note. The SQL/MX Release 2.x sample database uses SQL/MX format tables. To install the

sample database, you must have a license to use SQL/MX DDL statements. To acquire this

license, purchase product T0394. Without this product, you cannot install the sample database.

An error message informs you that the system is not licensed.