NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-23
Considerations—RIGHT_MARGIN
number
is an integer in the range 1 through 255 that indicates the rightmost byte position in
the report line. number must be greater than the LEFT_MARGIN layout option.
The default is the width of the output device.
Considerations—RIGHT_MARGIN
•
Report lines that extend beyond the margin continue on the next line. For default
detail lines, the point at which the lines break depends on the LOGICAL_FOLDING
option; for other lines, the point at which the lines break depends on the DETAIL
command. See LOGICAL_FOLDING Option
on page L-50 or DETAIL Command
on page D-43 for more information.
Lines might continue on a new line because of the output device width, even if the
lines are within the specified right margin. (Line continuation due to the output
device width is controlled by the WRAP option.) Output device widths are:
Examples—RIGHT_MARGIN
•
The example following sets the rightmost byte position of the report to 75:
>> SET LAYOUT RIGHT_MARGIN 75;
ROLLBACK WORK Statement
ROLLBACK WORK is a transaction control statement that undoes all database
modifications made to audited objects during the current TMF transaction, releases all
locks on audited objects held by the transaction, and ends the transaction. Without the
AUDITONLY clause, ROLLBACK WORK also releases all locks on nonaudited
objects locked during the transaction.
AUDITONLY
specifies that only locks on audited objects should be released.
If you specify AUDITONLY on a ROLLBACK WORK statement for a transaction
that locked nonaudited objects, you must explicitly close cursors or release locks on
Terminal 80 bytes
Unstructured disk
file
80 bytes
Structured disk file 80 bytes
Structured file Defined at file creation
Process 132 bytes (255 if RIGHT_MARGIN is greater than 132)
Printer 132 bytes (255 if RIGHT_MARGIN is greater than 132)
ROLLBACK WORK [ AUDITONLY ]