SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-34
SET DEFMODE Command
SET DEFMODE Command
SET DEFMODE is an SQLCI command that enables or disables the use of DEFINEs
in the current SQLCI session. (SET DEFMODE is similar to the TACL command SET
DEFMODE.)
ON
enables the use of DEFINEs. If DEFMODE is ON, you can execute commands that
contain DEFINE names and you can create, modify, or delete DEFINEs, display
information about DEFINES, and propagate existing DEFINEs to any processes
you start from the SQLCI session.
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.
Example—SET DEFMODE
This 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.
SET DEFMODE { ON } ;
{ OFF }
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 } }