SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
N-4
NEWLINE_CHAR Option
NEWLINE_CHAR Option
NEWLINE_CHAR is an option of the SQLCI report writer SET STYLE command that
specifies the character that indicates a new line in a column heading.
character
is a single-byte character to mark the end of a line in a heading string. The default
is “/”.
Consideration—NEWLINE_CHAR
For information about how to create headings, see DETAIL Command on page D-47.
Example—NEWLINE_CHAR
This example sets the new-line character to an exclamation point, then uses it in a
DETAIL command to create a two-line heading:
>> SET STYLE NEWLINE_CHAR "!";
S> DETAIL EMPNUM HEADING "Employee!Number" CENTER, ...
S> LIST FIRST 1;
Employee
Number
--------
234
Nonaudited Tables
Nonaudited tables are tables that are not audited by TMF, the main functional
component of the TMF product. TMF recovery operations do not protect nonaudited
tables from node failure or media failure.
NonStop SQL/MP creates audited tables by default but you can specify the creation of
a nonaudited table (or change an audited table to a nonaudited table) using the AUDIT
file attribute for the table.
For more information, see AUDIT File Attribute on page A-74 or TMF Transactions on
page T-6.
NEWLINE_CHAR "character"