SQL/MX Programming Manual for Java

Processing SQLJ Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
5-45
Interpreting the ProfilePrinter Output
The first three statement index entries, STATEMENT INDEX 0 to 2, describe an
internal system default setting for the SQL/MX executor and the system default
settings for the catalog and schema.
The statement index entries after STATEMENT INDEX 2 show the ready-to-compile
forms of the SQL/MX statements in the SQLJ program. In this example, the last
statement in the program is a cursor that selects rows from the EMPLOYEE table and
has a statement pattern of MX_CRSR_SAMPLEDML_SJPROFILE0_
1068249214683_11
:
--------- STATEMENT INDEX 17 ---------
PROCEDURE MX_CRSR_SAMPLEDML_SJPROFILE0_1068249214683_11 ()
DECLARE MX_CRSR_SAMPLEDML_SJPROFILE0_1068249214683_11 CURSOR FOR
SELECT first_name, last_name, empnum
FROM employee
WHERE (deptnum = 1000)
AND (jobcode = 100);
ALLOCATE STATIC OUTPUT DESCRIPTOR
MX_CRSR_SAMPLEDML_SJPROFILE0_1068249214683_11_OVAR FOR
CURSOR MX_CRSR_SAMPLEDML_SJPROFILE0_1068249214683_11(
VARCHAR(16) NULL,
VARCHAR(21) NULL,
NUMERIC(4, 0) NULL);