Edit code in query for iseries reports – IBM ISERIES SC41-5210-04 User Manual
Page 141
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
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