NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-45
DETAIL Command
can include the report functions LINE_NUMBER, COMPUTE_TIMESTAMP,
CURRENT_TIMESTAMP, and PAGE_NUMBER (which are not allowed in
numeric expressions other than in print items).
See Expressions
on page E-23 if you need details about the form of numeric
expressions.
AS format
specifies a format for printing the item using the syntax of the AS clause or the AS
DATE/TIME clause. (See AS Clause on page A-54 or AUDIT File Attribute on
page A-68 for details.)
If you use items of date-time types with AS DATE/TIME, first convert them to
Julian timestamps with JULIANTIMESTAMP. You cannot use AS with items of
type INTERVAL.
CONCAT (print-list) [ AS format ]
concatenates print items. See CONCAT Clause on page C-58 for a detailed
description of this clause.
IF cond-expr THEN ( print-list )
[ ELSE ( print-list ) ]
specifies a conditional expression that determines whether to print the specified
print list. See IF/THEN/ELSE Clause on page I-1 for a detailed description of this
clause.
HEADING "characters" [ CENTER ] | NOHEAD
characters to use as a heading for the print item. The heading can contain any single
or multibyte character.
To specify a multiline heading (up to 50 lines), include new-line characters in
characters to indicate the beginning of each new line. (The default new-line
character is slash (/). To change the default, see NEWLINE_CHAR Option
on
page N-3.)
By default, the heading is left justified. If you include CENTER, the heading is
centered over the print item.
NOHEAD specifies that the print item has no heading.
If you specify neither HEADING nor NOHEAD, report writer uses the default
heading in effect for the column. (See Determining Headings later in this entry for
an explanation of heading defaults.)
NAME detail-alias
specifies an SQL identifier unique among column names in the select list as the
detail alias for the print item.