SQL/MX Programming Manual for Java

Processing SQLJ Programs

HP NonStop SQL/MX Programming Manual for Java—523726-003

5-42

Example—SQLJ Run-Time Command Line

This example passes catalog value samdbcat and schema value persnl to the JVM

at run time. At an OSS prompt, enter this command to run the SQLJ program:

java -Dcatalog=samdbcat -Dschema=persnl SampleDML

ProfilePrinter Tool

Use the ProfilePrinter tool to print the contents of a profile (.ser file) in a

readable format for diagnostic purposes. By using the ProfilePrinter, you can look

at descriptions of both the embedded SQL/MX statement entries and the embedded

module definition (if the profile was customized).

The profile consists of a read-only area built by the SQLJ translator, serialized objects

of embedded SQL/MX statements, and an embedded module definition (if the profile

was customized). For more information, see Profile on page 1-12.

Command-Line Syntax

To invoke the ProfilePrinter tool, enter this command at an OSS prompt:

If you specify a JAR file, the ProfilePrinter tool displays only the profiles listed in

the manifest file of the JAR file. For more information, see Listing Profiles in a Manifest

File on page 6-6.

Example—ProfilePrinter

This command invokes the ProfilePrinter tool and redirects the output to a file:

java sqlj.runtime.profile.util.ProfilePrinter

SampleDML_SJProfile0.ser >> file.out

Interpreting the ProfilePrinter Output

Each block of output is designated by === bars:

•

Profile Information Block on page 5-43

•

Statement Entry Blocks on page 5-43

•

Embedded Module Definition Block on page 5-44

java [Java-options] sqlj.runtime.profile.util.ProfilePrinter

profile1.ser [MyApp.jar]...