NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-10
CENTER_REPORT Option
CENTER_REPORT Option
CENTER_REPORT is an option of the SQLCI report writer SET LAYOUT command
that controls whether reports are centered within the left and right margins.
Considerations—CENTER_REPORT
•
Centering a report
If you specify ON, the report writer centers the whole report as a block of text. To
compute the report width, the report writer examines lines of the report (including
titles, footings, detail lines, and so forth) and determines the leftmost and rightmost
positions containing data or text.
During these calculations, the report writer ignores lines defined with a CENTER
clause and leading and trailing TAB clauses. (In a TAB clause, the number you
specify relates to an absolute character position before the report is centered.)
The default is OFF.
Examples—CENTER REPORT
•
The following command centers all reports until you reset the CENTER_REPORT
option:
>> SET LAYOUT CENTER_REPORT ON;
Character Data Types
SQL includes both fixed-length character data and varying-length character data. Either
type of character data can be associated with a character set. Any character data type is
compatible with any other character data type that is associated with the same character
set, but not with numeric, date-time, or interval data types, and not with character data
that is associated with a different character set.
CENTER_REPORT { OFF }
{ ON }
Fixed-Length Types Varying-Length Types
CHAR[ACTER] CHAR[ACTER] VARYING
PIC X [DISPLAY] VARCHAR[ACTER]
NATIONAL
CHAR[ACTER]
NATIONAL CHAR[ACTER]
VAR Y I NG
NCHAR[ACTER] NCHAR[ACTER] VARYING