SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

D-46

Detail Alias

A detail alias is a name assigned to a print item using the NAME clause of the DETAIL

command. You can use a detail alias to refer to the print item in report formatting

commands such as TOTAL and SUBTOTAL, but not within the DETAIL command itself.

A detail alias is not the same as an alias, which is a name assigned to a column in the

select list of the SELECT command using the report writer NAME command. You can

use an alias (but not a detail alias) to refer to a column in any part of the report

definition.