SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-53
LOGICAL_FOLDING Option
LOGICAL_FOLDING Option
LOGICAL_FOLDING is an option of the SQLCI report writer SET LAYOUT command
that specifies where to break a default detail line (one for which there is no DETAIL
command) that does not fit within the report width.
ON
breaks the line before the first print item that does not fit. ON is the default.
OFF
breaks the line exactly at the right margin, even if the break is in the middle of a
print item.
Considerations—LOGICAL_FOLDING

The default right margin is the width of the current output device (OUT_REPORT
or OUT file). The default left margin is 0. Report width is right margin minus left
margin.

The LOGICAL_FOLDING option affects only lines that are folded because of the
report width. LOGICAL_FOLDING does not affect print lines that wrap because of
the output device length; such folding is controlled by the WRAP option.

LOGICAL_FOLDING does not affect output lines other than default detail lines. For
example, report writer displays output from the REPORT TITLE, BREAK TITLE,
and REPORT FOOTING commands according to the command specifications,
regardless of the setting of the LOGICAL_FOLDING option.
Example—LOGICAL_FOLDING
This example prints a report with LOGICAL_FOLDING ON (by default), and then with
LOGICAL_FOLDING OFF (after SET LAYOUT):
>> SET LAYOUT RIGHT_MARGIN 60;
>> SET LIST_COUNT 2;
>> SELECT * FROM INVENT.SUPPLIER;
SUPPNUM SUPPNAME STREET
------- ------------------ ----------------------
CITY STATE POSTCODE
-------------- ------------ ----------
1 NEW COMPUTERS INC 1800 KING ST.
SAN FRANCISCO CALIFORNIA 94112
2 DATA TERMINAL INC 2000 BAKER STREET
LAS VEGAS NEVADA 66134
S> SET LAYOUT LOGICAL_FOLDING OFF;
S> LIST FIRST 2;
LOGICAL_FOLDING { ON }
{ OFF }