SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-1
L
LEFT_MARGIN Option
LEFT_MARGIN is an option of the SQLCI report writer SET LAYOUT command that
sets the left margin for the current report and for subsequent reports until you reset it.
number
specifies the number of spaces to precede the leftmost printed character in the
report. number must be an integer in the range 0 through 255 and cannot exceed
the value of the RIGHT_MARGIN layout option. The default is zero.
Each space corresponds to a position that could be occupied by one single-byte
character, regardless of the character set in use.
Example—LEFT_MARGIN
This example sets the left margin to 10:
>> SELECT * FROM PERSNL.JOB;
S> LIST FIRST 1;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
S> SET LEFT_MARGIN 10;
S> LIST FIRST 1;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
LEFT_MARGIN number