SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
A-63
AS Clause
Specifies whether data in
C format is split at a blank
if possible.
“[F] C24.8” Manager
is on
leave.
|Manager |
|is on |
|leave. |
FL'c'
Specifies an ASCII
character to use when
data has fewer characters
than specified by an
alphanumeric descriptor,
when leading zeros are
suppressed, or when mask
text is not printed because
adjacent digits are not
printed. The default is a
blank.
“[FL'.'] A8”
“[RJ,FL'>']A8”
“[FL'*']M<$Z,ZZ9.99”
THEN
HERE
127.39
|THEN.... |
|>>>>HERE |
|$**127.39|
OC'c'
Specifies an ASCII
character to use as the
overflow character for the
current print item. (Does
not apply to alphanumeric
descriptors.)
“[OC'+']I2”
“[OC'>']F5.2”
100
100000.0
0
|++|
|>>>>>|
LJ
Left justify in display
format width. Applies only
to A descriptors; default for
A descriptors. Note that
data with leading blanks
will not look justified.
“[LJ]A8”
“[LJ]A3”
SQL
OREGON
|SQL |
|ORE|
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|
Table A-5. Modifiers (page 2 of 2)
Form and Usage Example Value Printed