IBM SC41-5210-04 manual Decimal point in Query for iSeries reports

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.03or

− 27.03.

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

Chapter 10. Specifying report column formatting in Query for iSeries 125