Filter
Top Products
v The Edit option value is the value last specified in the query definition, the value associated with the
field definition in the file definition (if this is a field from a file), or 1, if neither of the first two indicates its
value.
Generally, when you first come to the other four numeric field editing displays (identified on the Edit option
prompt of the Define Numeric Field Editing display), the displayed values are taken from the previously
saved values in your query definition, from the field definition in the file, and from the system-supplied
default values (in that order). Query uses edit code J as the default for edit option 3 and blank edit words
for edit option 4.
Describing numeric field editing in Query for iSeries reports
If you have determined that letting Query do the editing for you will not give you the results you want, you
can specify your own editing attributes. You do this on the Describe Numeric Field Editing display.
Describe Numeric Field Editing
Field......:
Type choices, press Enter.
Decimal point........ _ 1=. 2=, 3=: 4=$ 5=None
Thousands separator..... _ 1=. 2=, 3=’ 4=Blank 5=None
Show negative sign ..... _ Y=Yes, N=No
Left negative sign .... ______
Right negative sign.... ______
Show currency symbol .... _ Y=Yes, N=No
Left currency symbol . . . ______
Right currency symbol... ______
Print zero value ...... _ Y=Yes, N=No
Replace leading zeros.... _ Y=Yes, N=No
Replace with ....... _ 1=Blanks
2=Asterisks
3=Floating currency symbol
Single leading zero.... _ Y=Yes, N=No
F3=Exit F5=Report F10=Process/previous F12=Cancel
F13=Layout F16=Remove edit F18=Files
This display allows you to specify the editing characteristics that you want used for a numeric field. The
editing determines how the values for the field are to appear in your query report (if the report is run when
the edit option for the field is 1). You can select the characters to be used for the: decimal point,
thousands separator, a negative sign(s), and a currency symbol(s). You can specify separate negative sign
characters and separate currency symbol characters for either side of the field’s data values. You can also
specify whether zero values are to be printed and how leading zeros are to be handled.
This display shows the name of the numeric field to be edited and the numeric field editing override and
default values that will be used in the report. The editing values shown could be from IDDU or a
system-supplied edit description.
If you blank out all the values in the prompts on this display and press the Enter key, all the values are
then set to the system-supplied default values that are assumed by Query. These values are the same
default values used for result fields when they are first defined; thus, using this method, you can specify
the same type of editing for fields from files as is used for result fields, providing consistent editing in your
report.
To remove all editing overrides for this numeric field, press F16 (Remove edit). The asterisk (*) is removed
from the Edit column on the Specify Report Column Formatting display, and the editing values that will be
used for this field in the query report are taken from the field definition or from the system-supplied default
values.
124 Query for iSeries Use V5R2