SQL/MX Programming Manual for Java

Processing SQLJ Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
5-23
Option for Missing or Unavailable Database Objects
Specify customizer-specific options with the -P prefix as shown in this example:
java sqlj.tools.Sqlj -P-verbose -P-Ccatalog=cat
-P-Cschema=sch MyProg.sqlj
-ser2class
The -ser2class flag directs the SQLJ translator program to convert the generated
profiles (.ser files) to .class files.
For example, this command converts the generated profiles to .class files:
java sqlj.tools.Sqlj -ser2class=1 MyProg.sqlj
-sqlmx-compile
The -sqlmx-compile option controls the SQL compilation of module definition files
(.m). If you set -createMDF=true (or -SQLMXCustomizerVersion=800) to
generate module definition files, the SQLJ translator program automatically invokes the
SQL/MX compiler after successful customization, assuming that -sqlmx-compile is
true. If you set -sqlmx-compile to false on the command line, as this example
shows, SQL compilation of module definition files is suppressed:
java sqlj.tools.Sqlj -createMDF -sqlmx-compile=false MyProg.sqlj
-sqlmx-compiler-executable
The -sqlmx-compiler-executable option specifies the file name of the SQL/MX
compiler executable. By default, the SQL/MX compiler executable is MXCMP, which is
located in /G/system/system. You can specify another SQL compiler as this
example shows:
java sqlj.tools.Sqlj
-sqlmx-compiler-executable=/usr/username/mymxcmp MyProg.sqlj
If you do not specify the directory path along with name of the SQL/MX compiler
executable, the SQLJ translator program looks for the executable based the PATH
environment variable. For more information about the PATH environment variable, see
the NonStop Server for Java Programmer’s Reference.
Option for Missing or Unavailable Database Objects
Use this option to determine the how the translator and/or customizer process an SQLJ
program when database objects are unavailable at development time. This option
influences the behavior of an SQLJ program at run time. For more information, see
Missing or Unavailable Database Objects
on page 4-2.
-missingSQLObject
The -missingSQLObject flag determines whether an unavailable database object
referenced in an SQL statement is considered an error during translation and