NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-59
Decorations
Decorations
decoration
is condition location char-string
condition is one or more of the following:
Only P is allowed with character print items.
Specify multiple conditions without separators.
location
specifies where the character prints:
char-string
is a string to add to the print item.
RJ
Right justify in display
format width. Applies only
to A descriptors. Note that
data with trailing blanks
won't look justified.
“[RJ]A8”
“[RJ]A3”
SQL
OREGON
| SQL|
|GON|
SS'ss'
Changes a descriptor
symbol. First character in
pair is old symbol, second
is new. Use to change
mask descriptor symbols
(9,Z,V,.) and F descriptor
decimal point (.) symbol.
“[SS'.:']F6.2”
“[SS'.,']F8.2”
“[SS'9X'] M<XX/XX/19XX>”
12.45
12345.67
103191
|12:45|
|12345,67|
|10/31/1991
|
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.
Form and Usage Example Value Printed