Pathmaker Reference Manual

SQL Operation Attributes Screen
Pathmaker Screens
1–178 067869 Tandem Computers Incorporated
SQL Operation
Attributes Screen
The SQL Operation Attributes screen consists of two pages. Page one displays the
attributes for the retrieval operations and page 2 displays the attributes for the
modification operations. This screen is used only for services written in COBOL.
SQL Operation Attributes
Screen Page 1
Use page 1 of the SQL Operation Attributes screen to specify the attributes of
generated retrieval operations, SELECT and FETCH, for the current SQL IO section.
047
S Q L O P E R A T I O N A T T R I B U T E S PAGE 1/2
==============================================================================
Service Name: GLOBAL-SECURITY-TRANSMISSION
Logical File Name: EMP-TABLE
SQL IO Section Name: FIRST-EMP
Gen: X Select Access Type: S (Browse/Stable/Repeatable)
Lock Mode: S (Shared/Exclusive)
Gen: X Fetch Sort Direction: A (Ascending/Descending)
Position Mode: E (Exact/Approximate/Table)
Start Position: F (First/Current/Next)
Access Type: B (Browse/Stable/Repeatable)
Lock Mode: S (Shared/Exclusive)
For Modification: N (Y/N)
Access Path Name: EMP-NO_____________________________ Efficient: Y
Unique: Y
Implementation Macro Name: COBOL-SQL-OPERATIONS_________
==============================================================================
F2-Update F9-Value List F16-Return SF16-Exit
BLOCK
Displaying the Screen You reach the SQL Operation Attributes screen by placing the cursor on an entry and
pressing F7 from the SQL Operations screen.
Field Descriptions The following paragraphs describe the fields on page 1 of the SQL 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.