Pathmaker Reference Manual
SQL Operations Screen
Pathmaker Screens
067869 Tandem Computers Incorporated 1–187
SQL Operations
Screen
Use the SQL Operations screen to specify which SQL operations are to be generated
for the currently selected logical file (SQL table) of the current service. This screen is
used only for services written in COBOL.
049
S Q L O P E R A T I O N S
==============================================================================
Service Name: GDSONG-NEXT
Logical File Name: TEST-CB
Modif Retrieval
------- ----------------------------------
SQL IO Section Name U D I Access Path S F
FIRST-DEPENDENT_______________ x _ _ PRIMARY-KEY___________________ _ x
FIRST-EMP ____________________ x _ _ EMP-NO________________________ x _
NEXT-EMP______________________ _ _ _ EMP-NO________________________ _ x
______________________________ _ _ _ ______________________________ _ _
______________________________ _ _ _ ______________________________ _ _
______________________________ _ _ _ ______________________________ _ _
______________________________ _ _ _ ______________________________ _ _
______________________________ _ _ _ ______________________________ _ _
______________________________ _ _ _ ______________________________ _ _
______________________________ _ _ _ ______________________________ _ _
U=Update D=Delete I=Insert S=Select F=Fetch
Before-Image Host Variable: EMP-TABLE-BEFORE_____________
==============================================================================
F2-Update F4-List F7-Operation Attributes F16-Return
SF2-Delete F5-List Next F9-Value List SF16-Exit
BLOCK
Displaying the Screen You reach the SQL Operations screen by pressing F7 from the Logical File Entries
screen.
Field Descriptions The following paragraphs describe the fields on the SQL Operations screen.
Service Name
Displays the name of the service selected on the Logical File Entries screen before you
navigated to this screen.
Logical File Name
Displays the logical file (SQL table) of the service in the Service Name field.
SQL IO Section Name
Enter a name to be used as a Section name in the Procedure Division code generated
for the selected SQL operations.
The Pathmaker product uses this name as the name of a generated SQL cursor, where
hyphens are replaced by underscores.