SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

◦ “Inventory Class” (page 110)
◦ “LOWERPRICE Stored Procedure” (page 113)
◦ “DAILYORDERS Stored Procedure” (page 115)
◦ “MONTHLYORDERS Stored Procedure” (page 115)
◦ “ADJUSTSALARY Stored Procedure” (page 117)
◦ “EMPLOYEEJOB Stored Procedure” (page 118)
◦ “SUPPLIERINFO Stored Procedure” (page 119)
◦ “SUPPLYNUMBERS Stored Procedure” (page 120)
• Removed a note from the section “Portability” (page 20).
• Updated the Table 1 (page 32).
• Updated the section “Verifying the SQL/MX UDR Server” (page 33).
• Updated the section “Verifying the NonStop Server for Java” (page 34).
• Updated the section “Verifying the JDBC/MX Driver” (page 34).
• Updated the section “JREHOME Setting for the NonStop Server for Java” (page 35).
• Updated the section “Java Library Path for the JDBC/MX Native Library” (page 35).
• Added the section “Setting the JVM extensions location” (page 46).
• Removed a note from the section “Establishing Java Security” (page 46).
• Updated examples in the section “Null Input and Output” (page 52).
• Updated the section “Use of java.sql.Connection Objects” (page 53).
• Added a note to the section “Invoking SPJs in a NonStop ODBC/MX Client” (page 80).
Changes to the 691166-001 manual:
• Updated the section Verifying the SQL/MX UDR Server (page 33).
• Updated the section Naming the Procedure Label (page 66).
• Updated the section Calling an SPJ (page 71).
• Updated the section Transaction Statements or Methods in an SPJ Method (page 71).
• Added a new section Invoking SPJs in a Trigger (page 81).
• Updated the section CREATE PROCEDURE Statement (page 114).
• Updated the section CALL Statement to Invoke the SPJ (page 114).
Changes to the H06.16/J06.05 manual:
• Supported release statements have been updated to include J-series RVUs.
• Updated VALIDATEROUTINE2 internal SPJ details in Effect of Registering an SPJ (page 21).
• Updated Table 1: Software Products Required for SPJs (page 32).
• Updated the section Stored Procedure Result Sets (page 51).
• Updated the section Use of java.sql.Connection Objects (page 53).
• Added the section Specifying the Maximum Number of Result Sets (page 63).
• Added the section Using MXCI with SPJ RS (page 76).
• Added the section Output of the SHOWDDL Command of an SPJ with Result Sets (page 94).
10