SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Falling Back to SQL/MX Release 1.8
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
8-11
Converting Locally Placed User Modules to Globally
Placed User Modules
2. Fall back your SQL/MX Release 2.x environment to an SQL/MX Release 1.8
environment as described in Steps for Falling Back From SQL/MX Release 2.x to
SQL/MX Release 1.8 on page 8-3.
3. Verify that you are falling back to SQL/MX Release 1.8.5 AAV or later, which
supports locally placed modules. If not, see Converting Locally Placed User
Modules to Globally Placed User Modules on page 8-11.
4. If a module definition file was not found for an SQL/MX Release 2.x application in
Step 1, preprocess the application’s source file in SQL/MX Release 1.8 to generate
a module definition file.
5. In SQL/MX Release 1.8, host-language compile the SQL/MX Release 1.8
annotated source file created in Step 4. For more information about host language
compilation, see the
SQL/MX Programming Manual for C and COBOL.
6. In SQL/MX Release 1.8, use
mxcmp to SQL compile every SQL/MX Release 2.x
application’s module definition file to generate a new locally placed module.
Converting Locally Placed User Modules to Globally Placed
User Modules
1. In SQL/MX Release 1.8, make sure that the locally placed modules you will
convert to globally placed modules do not overwrite any existing module with the
same name in the
/usr/tandem/sqlmx/USERMODULES directory. You can
resolve any impending module name conflicts by:
•
Changing the MODULE directive in the application’s source file
•
Preprocessing the application, using the module naming directives on the
command line, and then language compiling, linking, and SQL compiling the
application as specified in the
SQL/MX Programming Manual for C and
COBOL.
2. Copy every locally placed module from its local directory to the
/usr/tandem/sqlmx/USERMODULES directory.
3. Remove the shared local copies of the now unused modules. To remove modules,
see the
SQL/MX Installation and Management Guide.