IBM SC41-5210-04 manual Specifying an edit code in Query for iSeries reports

Specifying an edit code in Query for iSeries reports

The Specify Edit Code display allows you to specify which edit code or user-defined edit description you want used to edit each value in a numeric field. The edit code or edit description that you choose determines how the values for the specified field are to appear in your query report (if the report is run when the edit option for the field is 3). For certain edit codes you can also specify a modifier character to be used as part of the editing.

The codes available are similar to the codes available to RPG/400* programmers.

To remove all the query-defined editing values for this numeric field (for this edit option and all the others), press F16 (Remove edit).

Specify Edit Code

Field . . . . . . . . :

Type choices, press Enter.

Edit code . . . . . . _ 1-4, A-D, J-Q, W-Z, user-defined 5-9

Optional edit code

modifier . . . . . _ 1=Asterisk fill 2=Floating currency symbol

F3=Exit	F5=Report	F10=Process/previous	F12=Cancel
F13=Layout	F16=Remove edit	F18=Files

Edit code in Query for iSeries reports

Type the character that identifies the edit code or edit description that you want used to edit the values in this field. You can specify any one of the following numbers or letters for edit codes: 1 through 4, A through D, J through Q, or W through Z. Or you can specify any one of the user-defined edit descriptions: 5 through 9.

Most of the edit codes are shown in the following table. The other edit codes (W, X, Y, and Z) and the user-defined edit descriptions (5 through 9) are listed after the chart.

			-- Value in QDECFMT			System Value: --
Edit	Print	Negative	Blank		I			J
Code	Commas	Symbol	Value		Value		Value
1	Yes	None	.00	or 0	,00 or	0	0,00	or 0
2	Yes	None	Blanks		Blanks		Blanks
3	No	None	.00	or 0	,00 or	0	0,00	or 0
4	No	None	Blanks		Blanks		Blanks
A	Yes	CR	.00	or 0	,00 or	0	0,00	or 0
B	Yes	CR	Blanks		Blanks		Blanks
C	No	CR	.00	or 0	,00 or	0	0,00	or 0
D	No	CR	Blanks		Blanks		Blanks
J	Yes	-	.00	or 0	,00 or	0	0,00	or 0
K	Yes	-	Blanks		Blanks		Blanks
L	No	-	.00	or 0	,00 or	0	0,00	or 0
M	No	-	Blanks		Blanks		Blanks
N	Yes	-	.00	or 0	,00 or	0	0,00	or 0
O	Yes	-	Blanks		Blanks		Blanks
P	No	-	.00	or 0	,00 or	0	0,00	or 0
Q	No	-	Blanks		Blanks		Blanks

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