SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

D-48

DETAIL Command

num-exp

is an numeric expression to evaluate and print in the detail line. The expression

cannot include the AVG, COUNT, MIX, MAX, or SUM functions. It can specify

columns with column names, aliases, or COL number, but not with detail aliases. It

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).

For information about the form of numeric expressions, see Expressions on

page E-21.

AS format

specifies a format for printing the item using the syntax of the AS clause or the AS

DATE/TIME clause. For information, see AS Clause on page A-60 or AUDIT File

Attribute on page A-74.

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. For description of this clause, see CONCAT Clause on

page C-63.

IF cond-expr THEN ( print-list )

[ ELSE ( print-list ) ]

specifies a conditional expression that determines whether to print the specified

print list. For description of this clause, see IF/THEN/ELSE Clause on page I-1.

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-4.)

By default, the heading is left justified. If you include CENTER, the heading is