IBM @server iSeries, User Manual

Page: 137 / 294

Decimal point in Query for iSeries reports
Type the option number of the character that you want used as the decimal point in this field. The option
numbers and characters are shown below, along with examples of the edited results for a numeric value of
245.87
:
Option Example Meaning of Option
1= . 245.87 Decimal point is a period
2= , 245,87 Decimal point is a comma
3= : 245:87 Decimal point is a colon
4= $ 245$87 Decimal point is a dollar sign
5=None 24587 Decimal point not used
Thousands separator in Query for iSeries reports
Type the option number of the character that you want used as the thousands separator in this field. The
option numbers and characters are shown below, along with examples of the edited results for a value of
1515109
:
Option Example Meaning of Option
1= . 1.515.109 Separator is a period
2= , 1,515,109 Separator is a comma
3= ’ 1’515’109 Separator is an apostrophe
4=Blank 1 515 109 Separator is a blank space
5=None 1515109 Separator not used
Show negative sign in Query for iSeries reports
Type a
Y
or
N
to indicate whether a negative sign is to be used with this field.
Y=Yes
A negative sign is to be shown when the value in the field is negative. The sign can be on the left or
right side of the value (or on both sides), and it can be defined differently for each side. All negative
signs take space in the report. Use the next two prompts to define from 1 to 6 characters for the
negative sign(s). (You can leave one prompt blank. If you do, no sign shows on that side of the field
and no space is taken in the report.)
N=No
A negative sign is not to be shown when the value in the field is negative. If the next two prompts
contain negative sign definitions, they are saved in this query but not used.
Left negative sign in Query for iSeries reports
Type from 1 to 6 characters that you want used as the negative sign to appear on the left of negative
values in this field. Any character that can be printed or displayed can be used. Either the blank or
underscore (_) can be used within the character string, but if you want blanks at the
right end of the string
for the negative sign, you must use underscores.
Some examples of left negative signs for the negative value of
27.03
are:
Sign Edited Negative Value
- -27.03
CRAMT CRAMT27.03
CR AMT CR AMT27.03
CRDT:_ CRDT: 27.03
The coding for the last example must include an underscore because of the blank at the right end of the
left negative sign characters.
The position of the left negative sign depends on the value specified in the Replace with option when
leading zeros are to be replaced.
v
If you specify option 1 (Blanks) or option 2 (Asterisks), the negative sign is fixed; it is always shown in
the farthest left position of the field, to the left of all the asterisks that replace all leading zeros. For
example, in a field with a length of eight digits, the edited value for
27.03
would be
-****27.03
or
− 27.03
.
Chapter 10. Specifying report column formatting in Query for iSeries
125