Pathmaker Reference Manual

SQL Operation Attributes Screen
Pathmaker Screens
067869 Tandem Computers Incorporated 1–183
SQL Operation Attributes
Screen Page 2
Use page 2 of the SQL Operation Attributes screen to specify the attributes of
generated modification operations—UPDATE, DELETE, and INSERT—for the current
SQL IO section.
048
S Q L O P E R A T I O N A T T R I B U T E S PAGE 2/2
==============================================================================
Service Name: GLOBAL-SECURITY-TRANSMISSION
Logical File Name: EMP-TABLE
SQL IO Section Name: FIRST-EMP
Gen: X Update Concurrency Check: N (None/Row)
Access Type: S (Stable/Repeatable)
Gen: X Delete Concurrency Check: N (None/Row)
Access Type: S (Stable/Repeatable)
Gen: X Insert Access Type: S (Stable/Repeatable)
Implementation Macro Name: COBOL-SQL-OPERATIONS_________
==============================================================================
F2-Update F9-Value List F16-Return SF16-Exit
BLOCK
Displaying the Screen You reach the second page of the SQL Operation Attributes screen by pressing NEXT
PAGE from page 1 of the SQL Operation Attributes screen.
Field Descriptions The following paragraphs describe the fields on page 2 of the Operation Attributes
screen.
Service Name
Displays the name of the currently selected service from the SQL Operations screen.
You cannot enter data into this field.
Logical File Name
Displays the name of the currently selected logical file of the SQL table from the SQL
Operations screen. You cannot enter data into this field.
SQL IO Section Name
Displays the section name in the procedure division code generated for the selected
SQL operations, as transferred from the SQL Operations screen. You cannot enter data
into this field.