SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Embedded-Only SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
3-72
C Examples of MODULE
Directive Used by the Customizer
The SQLJ customizer creates a module definition file, containing only SQL statements,
as one of its output files. The customizer writes the header of the module definition file
as:
MODULE module-name NAMES ARE ISO88591 ;
TIMESTAMP DEFINITION ( creation_timestamp ) ;
The customizer gets the module-name from the MODULE directive, if one exists, at
the beginning of your embedded SQLJ program.
Automatic Generation of Module Names
If you do not specify a MODULE directive, the preprocessor or customizer generates a
module name for you. If you change your source program and process and compile it
again, the new module overwrites the old module. System-generated module names
can become a management problem if you want to create different versions of your
program. For information on module management, see the SQL/MX Programming
Manual for C and COBOL or the SQL/MX Programming Manual for Java.
C Examples of MODULE
•
This example shows a MODULE directive:
EXEC SQL MODULE EXF61M NAMES ARE ISO88591;
COBOL Examples of MODULE
•
This example shows a MODULE directive:
EXEC SQL MODULE EXF62M NAMES ARE ISO88591 END-EXEC.
Java