SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Utilities
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
5-76
Guidelines for map-file
-help
provides information on how to use the tool.
Guidelines for map-file
The guidelines to create a map file are:
•
Specify a single mapping between a compile time and runtime table or view name.
This tool stops processing and returns an error if it detects more than one mapping
for the same compile time table or view.
•
Specify three part ANSI names for compile time and runtime names.
•
All references to the PROTOTYPE table or view will be mapped to the runtime
table or view provided in the map-file.
•
Mappings are not required for indexes.
Guidelines for module-list-input-file
The guidelines to create a module-list-input-file are:
•
List each module file on a separate line.
•
This tool does not process system module files. It processes the module files
sequentially and stops if it finds a system module file.
•
You must have read and write permissions on the module file.
•
If the full path for the module file is not specified, this tool uses the following search
sequence for the module file:
°
Local directory (from where you launch the tool)
°
User specified directories using the environment variables or Guardian
DEFINES
°
Global module directory
•
If the full path is specified and the file does not exist, the tool will not process the
module file.
Guidelines for log-file
•
If the absolute path is not specified, this tool searches for the file in the current
directory. It creates a file if the file does not exist. If the file exists, this tool renames
the existing file with an extension .sqlmx.bak and creates a new file. If the file
with extension .sqlmx.bak already exists, this tool purges the file.
Note. HP recommends that you take a backup of the module files before processing.
Note. You must have read permission on the map-file and search permission on the directory.