IBM SC41-5210-04 manual F10=Process/previous F12=Cancel F13=Layout

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

124Query for iSeries Use V5R2