Pathmaker Reference Manual

SQL Operation Attributes Screen
Pathmaker Screens
1–184 067869 Tandem Computers Incorporated
Gen: Update
Enter X (or any other non-blank value) to specify the UPDATE attribute. A non-blank
in this field indicates that code is to be generated for the named operation. The
attribute values displayed to the right of UPDATE are meaningful only if UPDATE is
marked.
Concurrency Check
Enter a value to indicate whether concurrency checking code is to be generated for the
UPDATE operation.
R Row - Code is generated to verify that all columns from the table row being
modified are identical to the values from the original row in the "Before-Image
Host Variable."
N None (default) - No concurrency checking is performed.
Access Type
Enter a value to indicate the SQL locking access type for the UPDATE operation.
S Stable (default)
R Repeatable
Gen: Delete
Enter X (or any other non-blank value) to specify the DELETE attribute. A non-blank
in this field indicates that code is to be generated for the named operation. The
attribute values displayed to the right of DELETE are meaningful only if DELETE is
marked.
Concurrency Check
Enter a value to indicate concurrency checking code is to be generated for the DELETE
operation.
R Row - Code is generated to verify that all columns from the table row being
modified are identical to the values from the original row in the host variable.
N None (default) - No concurrency checking is performed.
Access Type
Enter a value to indicate the SQL locking access type for the DELETE operation.
S Stable (default)
R Repeatable
Gen: Insert
Enter X (or any other non-blank value) to specify the INSERT attribute. A non-blank
in this field indicates that code is to be generated for the named operation. The
attribute values displayed to the right of INSERT are meaningful only if INSERT is
marked.