SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
5-125
Considerations

To display logging information on the terminal, specify the -log option without a
filename. If the option is not specified, only summary report is displayed. Do not
use the wildcards in the log file name.
Considerations
The following are considerations when running this tool:

It supports only SQL/MX tables or views.

It does not support SQL/MP tables or views. If a statement accesses SQL/MP
tables or views, SQL/MP tables using MP aliases or both SQL/MP and SQL/MX
objects, this tool skips the statement and does not update the redefinition
timestamps or the ANSI names.

It does not process SQL/MX queries using DEFINEs.

It uses the existing Similarity Check criteria to determine if the compile time and
runtime tables or views are similar. It does not override any existing Similarity
Check criteria. If the Similarity Check fails for a statement, this tool does not
update the redefinition timestamps for the statement. An automatic recompilation
occurs for these statements if Similarity Check is enabled at runtime.

If you compile the module files with Similarity Check disabled, this tool skips
Similarity Check on statements in these module files.

It processes only OSS module files. You can provide an absolute path for the
module file. If the absolute path is not specified, the module file is searched using
the search criteria. For more information, see Guidelines for module-list-input-file
on page 5-124.

It creates a temporary module file in the location specified by TMPDIR environment
variable. If TMPDIR is not set, this tool creates a temporary module file in the
current directory. If both TMPDIR and current directories are Guardian locations,
this tool returns an error. You must have the read and write permissions for these
locations.
If the temporary module file, which is composed by appending _sqlmx_temp to the
module file name, already exists, this tool returns an error.
It replaces the original module file with the temporary module file upon successful
processing of the module file. You must have write permission on the module file
directory.
This tool purges the temporary module file if there is an error in processing or there
are no changes to the original module file.
Note. You must have write and search permission on the directory to create a log file. If a log
file exists, you must have write permission on the file.