Pathmaker Programming Guide

Modifying the SQL Generation Macro
Advanced Pathmaker Programming Topics
9–52 067868 Tandem Computers Incorporated
Modifying the SQL
Generation Macro
The Pathmaker product provides an SQL Generation Macro that acts as a framework
for generated NonStop SQL data manipulation statements for COBOL85 services. This
macro consists of NonStop SQL source text lines for COBOL85 plus Pathmaker macro
language command lines.
The file containing the macro (CBSQLMAC) is found on the subvolume on which the
object files for this version of the Pathmaker product are installed. The Pathmaker
name for the macro is COBOL-SQL-OPERATIONS; use this name on the Operation
Attributes screen in the Implementation Macro Name field.
As with the Pathmaker skeleton files, you can copy this macro and make certain
changes to it. Before you change the original SQL generation macro on the release
subvolume, you should make a backup copy of the file. Changes made to the original
SQL generation file affect all generated SQL operations for this Pathmaker project.
An alternative method is to create several edited macros for use in various portions of
your application or for various Pathmaker projects. To create additional SQL
generation macros, follow these steps:
1. Make a copy of the original macro.
2. Make changes to the new macro.
3. Register the new macro using the Macro Registration screen.
4. Use the new macro when specifying information on the Operations Attributes
screen.
Caution You must reapply any changes to the original SQL generation macro in later releases of the product.
Tandem does not assume responsibility for changes made to the macro.
If you do decide to create additional SQL generation macros, be sure to inform
application developers of the name of the macro to use.