SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-60
AS Clause
AS Clause
The AS clause is an SQLCI report writer clause that specifies a display format for a
print item. You can use the AS clause in the BREAK FOOTING, BREAK TITLE,
DETAIL, PAGE FOOTING, PAGE TITLE, REPORT FOOTING, and REPORT TITLE
report writer commands.
display-descriptor
specifies a format.
scale-sign-descriptor
specifies scale for a fixed point display descriptor or controls printing of a plus sign.
decoration
specifies character strings to conditionally add to a print item.
modifier
alters the effect of descriptors.
These tables in this entry describe descriptors for character items, descriptors for
numeric items, scale-sign descriptors, decorations, and modifiers, respectively:

Display Descriptors for Character Items on page A-61

Display Descriptors for Numeric Items on page A-61

Scale-Sign Descriptors on page A-62

Modifiers on page A-62

Decorations on page A-64
For a description of how to format dates and times in Julian timestamps, see AUDIT
File Attribute on page A-74.
{ display-descriptor }
{ }
{ "scale-sign-descriptor display-descriptor" }
{ }
{ " "[" [ decoration [, decoration ] ... ] }
AS { [ modifier [, modifier ] ... ] "]" }
{ display-descriptor" }
{ }
{ " "[" [ decoration [, decoration ] ... ] }
{ [ modifier [, modifier ] ... ] "]" }
{ ( scale-sign-descriptor }
{ display-descriptor )" }