NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-44
DETAIL Command
command, even though it may be printed as more than one row in a report.) You can use
DETAIL only from the select-in-progress prompt, not from the SQLCI prompt.
column-id
is a column in the select list of the SELECT command to print in the detail line.
column-id can be a column name, an alias, or COL number (which specifies the
position of the column in the select list). It cannot be a detail alias.
literal
is a string literal to print in the detail line.
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
DETAIL [ print-list ] ;
print-list is:
print-item [ , print-item ] ... ]
print-item is:
{ { { column-id } [AS format] }[head] [name]}
{ { { literal } } }
{ { { num-exp } } }
{ { } }
{ { CONCAT (print-list)[AS format]} }
{ { } }
{ { IF cond-expr THEN (print-list)} }
{ { [ ELSE (print-list) ] } }
{ }
{ NEED [number] }
{ }
{ PAGE [number] }
{ }
{ SKIP [number] }
{ }
{ SPACE [number] }
{ }
{ TAB [number] }
head is:
HEADING "characters" [ CENTER ] | NOHEAD
name is:
NAME detail-alias