SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-58
SPACE Option
SPACE Option
SPACE is an option of the SQLCI report writer SET LAYOUT command that specifies
the default number of spaces between columns of report print items. Each space
occupies a single byte position, regardless of the character set in use.
number
is an integer in the range 0 through 255 that specifies the default number of spaces
between print items.
The default is 2.
Considerations—SPACE

If you specify the SPACE clause on the DETAIL command, the value you specify
overrides the value of the SPACE layout option for that detail line.

SQL does not print spaces before or after a string literal in a report unless you
specify a heading for the report column that includes the string literal. If you specify
a heading, SQL prints the default number of spaces before and after the string
literal.
Examples—SPACE

This example demonstrates that SQL does not print spaces before or after a string
literal unless the report column that includes the string literal has a heading:
>> SET LIST_COUNT 0;
>> SELECT * FROM PERSNL.JOB;
S> DETAIL JOBCODE, "***", JOBDESC;
S> LIST NEXT 4;
JOBCODE JOBDESC
------- ------------------
100***MANAGER
200***PRODUCTION SUPV
250***ASSEMBLER
300***SALESREP
S> DETAIL JOBCODE, "***" HEADING " ", JOBDESC;
S> LIST FIRST 4;
JOBCODE JOBDESC
------- --- ------------------
100 *** MANAGER
200 *** PRODUCTION SUPV
250 *** ASSEMBLER
300 *** SALESREP
SPACE number