SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-62
AS Clause
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.
Table A-4. Scale-Sign Descriptors
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.
Table A-5. Modifiers (page 1 of 2)
Form and Usage Example Value Printed
BZ
Prints a blank field if the
value is zero.
“[BZ] F8.2”
“[BZ] F8.2”
.00
123.00
| |
|123.00|
F
Table A-3. Display Descriptors for Numeric Items (page 2 of 2)
Form and Usage Example Value Printed
d, w, and n are unsigned integers in the range 1-255.
| | indicates the boundaries of the output field.