SQL/MX Programming Manual for Java

Processing SQLJ Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
5-26
Options for the SQLJ Customizer
Options for the SQLJ Customizer
Use these options to influence how the SQLJ customizer processes the profiles of a
program. The -P prefix before each option is optional.
-backup
The -backup option specifies whether to back up the profiles before customization,
which extends the profile with customized run-time information. This option is helpful if
you plan to customize a program and want keep the original profile or profiles.
If you set -backup to true, the SQLJ translator program creates copies of the original
profiles in backup files named MyProg_SJProfileNum.ser.bak.
For example, enter:
java sqlj.tools.Sqlj -P-backup MyProg.sqlj
The SQLJ translator program creates a backup file of the profile named
MyProg_SJProfile0.ser.bak.
-P-help
The -P-help flag directs the SQLJ translator program to display information about the
command-line options of the SQLJ customizer. For example, this command displays
the help text of the SQLJ customizer:
java sqlj.tools.Sqlj -P-help
-showPrepare
The -showPrepare option, when set to true, displays the text of each SQL statement
as the customizer prepares, or precompiles, the statement by using JDBC.
For example, this command sets the -showPrepare option to true:
java sqlj.tools.Sqlj -showPrepare=true MyProg.sqlj
The command displays these messages:
MyProg_SJProfile0.ser: Info: Line# 34:
delete from tblcha01
MyProg_SJProfile0.ser: Info: Line# 35:
insert into tblcha01(a1, char01) values( ? , ? )
MyProg_SJProfile0.ser: Info: Line# 36:
select a1, char01 from tblcha01 where a1= ?
-SQLMXCustomizerVersion
The -SQLMXCustomizerVersion option specifies a version of SQL/MX and a set of
version-specific default settings to be used by the SQLJ customizer.
If you specify 800 for SQL/MX Release 1.8, the -SQLMXCustomizerVersion option
sets the -createMDF option to true and causes the customizer to generate a module