Pathmaker Programming Guide

Modifying the SQL Generation Macro
Advanced Pathmaker Programming Topics
067868 Tandem Computers Incorporated 9–53
Changes you can make to the SQL generation macro include:
Modifying the syntax of generated SQL statements. For example, you can change
the INSERT statement for a relative file to use the APPEND option instead of the
ANYWHERE option as follows:
SQL-INSERT.
.
.
.
% if #Access-Method = "Relative" use 1 lines
ANYWHERE <- Change to APPEND
END-EXEC.
Adding application code that must be executed each time a certain generated SQL
operation is performed. For example, if every INSERT operation required a
validity check on the data, you could add code that would become part of every
generated INSERT operation to the SQL generation macro file.
Creating a modified macro to be used during application development that
includes debugging statements in the generated SQL code such as statements to
display host variables on the home terminal.