NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
A-57
Display Descriptors for Numeric Items
Display Descriptors for Numeric Items
Scale-Sign Descriptors
Form and Usage Example Value Printed
Fw.d [.m]
Fixed point field, w print positions
wide with d significant digits to the
right of the decimal and m to the left.
Right justify, blank fill, leading zeros
if needed.
F8.4
F8.4
F8.4.2
“[FL'*']F8.2”
123.4567
0.000123 -
4.56789
123.4567
|123.4567|
| 0.0001|
|-04.5679|
|**123.46|
Iw [.m]
Integer field, w print positions wide
that contains m digits. Right justify,
blank fill, leading zeros.
I8
I8.2
I8.6
100
-1
100
| 100|
| -01|
| 000100|
M
Mask string in angle brackets,
apostrophes, or quotes is template for
display. Field is same width as mask,
excluding V's. Mask does not affect
scale.
M”99/99/99”
M'Z,ZZ9.99'
M<Z,ZZZ>
M<9,999>
M<9,999>
M<$Z,ZZ9.99>
M<$Z,ZZ9V99>
112388
32.009
666
666
66666
920.00
920.00
|11/23/88|
| 32.01|
| 666|
|0,666|
|*****|
|$ 920.00|
|$ 92000|
Ordinary characters in the mask appear in the display. These characters have special meanings:
Z Selects digits. Prints a blank for each leading or trailing zero. Use with character or numeric data. Must
be uppercase Z.
9 Selects digits. Prints zero if no digit exists. Use for numeric data only.
V Aligns the decimal point of the value but does not print a decimal point. Must be uppercase V.
. Aligns the decimal point of the value and prints a decimal point (the character specified in the
DECIMAL_POINT style option) at that position.
d, w, and n are unsigned integers in the range 1-255.
| | indicates the boundaries of the output field.
Form and Usage Example Value Printed
nP
Scale factor 10**n. n is
-128 to 127.
“2P F8.2”
“-2P F8.2”
123.00
123.00
|12300.00|
| 1.23|
S or SS (default) Omit plus
sign.
“S, F8.2”
“SS,-2P F8.2”
123.00 123.00 |123.00|
| 1.23|
SP
Print plus sign. “SP, F8.2”
“SP, F8.2”
123.00
-123.00
|+123.00 |
|-123.00 |
| | indicates the boundaries of the output field
An S, SS, or SP scale-sign descriptor must be separated from a display descriptor by a comma.