SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-64
Decorations
Decorations
decoration
is condition location char-string
condition is one or more of:
Only P is allowed with character print items.
Specify multiple conditions without separators.
location
specifies where the character prints:
char-string
is a string add to the print item.
Rules for Using Decorations

Specify decorations immediately before the descriptors they modify. Enclose the
decorations and the modified descriptors in quotation marks (“”).

Separate multiple decorations by commas and enclose decorations and modifiers
in brackets.

With the overflow condition (O), use only the form location An.

The default overflow character is the current OVERFLOW_CHAR option.
Decoration OC overrides the default but does not change it.

A print position is one byte; each double-byte character requires two print
positions.

Without decorations, a negative value prints with a preceding minus. If you specify
a decoration that tests for a positive value, however, the preceding minus is no
longer the default for negatives; you must explicitly request the negative sign.
M Add char-string if value is negative
P Add char-string if value is positive
Z Add char-string if value is zero
O Add char-string if overflow condition occurs
An Display at print position n of the field. (The leftmost position is 1.)
F Insert string after formatting value; print string immediately to the right of a
left-justified item, immediately to the left of a right-justified item.
P Insert string before formatting value; print string immediately to the right of
a right-justified item, immediately to the left of a left-justified item.