SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

R-21

Consideration—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.

For other lines, see LOGICAL_FOLDING Option on page L-53 or DETAIL Command

on page D-47.

Lines might continue on a new line because of the output device width, even if the lines

are within the specified right margin. (Such line continuation is controlled by the WRAP

option.) Output device widths are:

Example—RIGHT_MARGIN

This example sets the right most 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 the nonaudited objects by using CLOSE cursor and UNLOCK TABLE or FREE

RESOURCES.

Terminal 80 bytes

Unstructured disk file 80 bytes

Structured disk file Record length set at file creation

Edit file 80 bytes (239 if RIGHT_MARGIN is greater than 80)

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 ]