NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-35
Examples—SET DEFMODE
ON is the default.
OFF
disables the use of DEFINEs. With DEFMODE OFF, you cannot execute commands
that contain DEFINE names and you cannot add DEFINEs or propagate existing
DEFINEs to another process. You can modify, delete, and display information about
existing DEFINEs.
Examples—SET DEFMODE
•
The following example enables the use of DEFINEs:
>> SET DEFMODE ON;
SET LAYOUT Command
SET LAYOUT is an SQLCI report writer command that sets layout options. Layout
options affect the way a report appears on the screen or printed page.
You cannot specify the same option more than once in a single SET LAYOUT
command.
For information about a specific option, see the entry for that option.
Examples—SET LAYOUT
•
The following command sets the left margin for reports at byte position eight and
also sets double spacing:
>> SET LAYOUT LEFT_MARGIN 8, LINE_SPACING 2;
SET [ LAYOUT ] option [ , option ] ... ;
option is:
{ CENTER_REPORT { OFF | ON } }
{ LEFT_MARGIN number }
{ LINE_SPACING number }
{ LOGICAL_FOLDING { ON | OFF } }
{ PAGE_COUNT { number | ALL } }
{ PAGE_LENGTH { number | ALL } }
{ RIGHT_MARGIN number }
{ SPACE number }
{ WINDOW { TAB number | column } }