IBM SC41-5210-04 manual Right negative sign in Query for iSeries reports

vIf 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.

126Query for iSeries Use V5R2