SQL/MX Programming Manual for Java

Processing SQLJ Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
5-43
Interpreting the ProfilePrinter Output
Profile Information Block
The first block provides general information about the profile:
•
Name of the .ser file (SampleDML_SJProfile0)
•
Date and time when profile was printed (11/7/03 3:53 PM)
•
Name of the serialized connection context object (DefConCtx),
•
Default loader used to load the profile
•
Whether the profile is customized or not
•
Name of the associated SQLJ source file (SampleDML.sqlj)
•
Number of profile entries (12).
Statement Entry Blocks
Each statement entry block describes an embedded SQL/MX statement.
The second block in the profile, after the profile information block, describes the first
statement entry (entry 0). For example, the SQL/MX statement described in this
entry is #sql { MODULE samdbcat.persnl.dmlmod }, which is located at line
number 23 in the SampleDML.sqlj file. The statement type is
PREPARED_STATEMENT and is executed by the EXECUTE_UPDATE method. The
role of the statement (MXMODULE) is to produce a module name. The statement does
not accept input host variable values and does not return data.
The third block describes the second statement entry (entry 1). For example, the
SQL/MX statement described in this entry is #sql { SET CATALOG 'SAMDBCAT'
}
, which is located at line number 66 in the SampleDML.sqlj file. The statement type
is PREPARED_STATEMENT and is executed by the EXECUTE_UPDATE method.
The role of the statement (MXDECLARE) is to declare the catalog name. The
statement does not accept input host variable values and does not return data. It is
customized for NonStop SQL/MX. Its statement pattern is MX_STMT_0_1 and is
===================================================
printing contents of profile SampleDML_SJProfile0
created 1068249214683 (11/7/03 3:53 PM)
associated context is DefConCtx
profile loader is sqlj.runtime.profile.DefaultLoader@15ee671
contains one customization
com.tandem.sqlj.Customizer.CustInstall$CustomizationMX@13d93f4
original source file: SampleDML.sqlj
contains 12 entries
===================================================
===================================================
profile SampleDML_SJProfile0 entry 0
#sql { MODULE samdbcat.persnl.dmlmod };
line number: 23
PREPARED_STATEMENT executed via EXECUTE_UPDATE
role is MXMODULE
descriptor is DIRECTIVE=MODULE,VALUE=dmlmod,VALUE=ISO88591
contains no parameters
result set type is NO_RESULT
result set name is null
contains no result columns
===================================================