Filter
Top Products
v If you specify option 3 (Floating currency symbol), then the negative sign moves (or floats), depending
on how many leading zeros it replaces, so that it is to the immediate left of the first significant digit in
the value (such as −27.03), or it is to the immediate left of the left currency symbol (such as −$27.03).
Right 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 right 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. Examples of right negative signs are 27.03−, 27.03CR
AMT, and 27.03 CRDT.
Show currency symbol in Query for iSeries reports
Type a Y or N to indicate whether a currency symbol is to be used with this field.
Y=Yes
A currency symbol is to be shown with the value in the field. The symbol can be on the left or right
side of the value (or on both sides), and it can be defined differently for each side. If option 3 (Floating
currency symbol) is not specified below in the Replace with prompt (for leading zeros), then the left
currency symbol (if used) appears in a fixed position in the field. However, if option 3 is used, then any
left currency symbol specified will be a floating symbol, depending on how many leading zeros it
replaces. Use the next two prompts to define from 1 to 6 characters for the currency symbol.
N=No
A currency symbol is not to be shown with the value in the field. If the next two prompts contain
currency symbol definitions, they will be saved in this query but not used.
Left currency symbol in Query for iSeries reports
Type from 1 to 6 characters that you want used as the currency symbol to appear on the left of values in
this field. Any character that can be printed or displayed can be used, but you should not use an asterisk
(*), zero, or whatever your decimal point is (such as the period). 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 symbol, you
must use underscores.
Some examples of left currency symbols that might be used with a value of 45.5 are:
Symbol Edited Result Possible Use
L. L.45.5 Italy
Kr Kr45.5 Norway
$ $45.5 U.S.
THOUS_ THOUS 45.5 U.S.
This string is positioned in the same way as you typed it, unless you choose to replace the leading zeros
with the floating currency symbol. In that case, this string is moved (floats) to the immediate left of the first
significant digit.
Right currency symbol in Query for iSeries reports
Type from 1 to 6 characters that you want used as the currency symbol to appear on the right of values in
this field. Any character that can be printed or displayed can be used, but you should not use an asterisk
(*), zero, or whatever your decimal point is (such as the period). 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 symbol, you
must use underscores.
Some examples of right currency symbols that might be used with a value of 123.45 are:
Symbol Edited Result Possible Use
_BF 123,45 BF Belgium
F 123,45 F France
$ 123.45$ U.S.
THOUS 123.45THOUS U.S.
> 123.45> U.S.
126 Query for iSeries Use V5R2