Pathmaker Reference Manual

SQL Operations Screen
Pathmaker Screens
1–188 067869 Tandem Computers Incorporated
The name in this field must be unique among all SQL operations entries for this
service; you need to ensure that this name is not used as a COBOL section or
paragraph name, nor as an SQL cursor in user-supplied or other generated code.
Modif - U D I
Enter any non-blank character to generate modification operations:
U Updates
D Deletes
I Inserts
Retrieval - Access Path
Enter the name of an existing access path for the current table. If you specify a
SELECT or FETCH in the next field for this line entry, you must enter an access path.
Otherwise, it is optional.
Retrieval - S F
Enter non-blank character to generate retrieval operations:
S Selects
F Fetches
If you specify an S, the named access path in the previous field must be unique.
Before-Image Host Variable
Enter the name of the Working Storage variable to be generated to hold the "before"
image used in concurrency checking prior to an update operation. This name must
not conflict with variable names elsewhere in the service.
The default value for this field is "<truncated-table-object-name>-BEFORE", where the
table object name is truncated to 23 characters, eliminating double hyphens.
Functions The following paragraphs summarize the functions available on the SQL Operations
screen, including those functions that are not displayed on the screen.
F2-Update
Updates the values you entered.
F4-List
Lists the first set of up to 10 SQL operations entries for the current logical file and the
current service.
F5-List Next
Lists a following set of up to 10 SQL operation entries for the current logical file and
the current service.