SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-47
DETAIL Command
DETAIL Command
DETAIL is an SQLCI report writer command that defines the contents and format of a
detail line. (A detail line is the output from a single row returned by a SELECT
command, although it can 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.
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