IBM SC41-5210-04 Specifying edit words, Optional edit code modifier in Query for iSeries reports

Optional edit code modifier in Query for iSeries reports

Type the character that you want used as the optional modifier for the specified edit code. If you specified one of the edit codes W through Z or one of the edit descriptions 5 through 9 in the Edit code prompt, you cannot specify an optional modifier in this prompt.

1=Asterisk fill

Asterisks (*) are to be used as the fill character to replace leading zeros for this field; for example,

****27.03.

2=Floating currency symbol

The currency symbol specified in the QCURSYM system value is to be used as the edit code modifier for this field. An example is the dollar sign ($), as in $27.03.

Specifying edit words

Specifying or creating an edit word is another way to define numeric editing. It should be considered when the first three methods do not produce the results you want.

The Specify Edit Word display allows you to specify or change the edit word(s) that you want used to edit a numeric field. An edit word determines how all the values for the specified field are to appear in your query report if the report is run when the edit option for this field is 4.

You can use one edit word to edit all the detailed values for the field and, if the total summary function was specified for the field, you can use another edit word to edit the summary total values for the field.

A blank string enclosed in apostrophes appears as the default for the detailed values edit word for a field that does not have an edit word specified in its definition.

To remove only the edit word used for this field’s summary totals, blank out the Edit word for summary total prompt. If you want to remove both edit words defined for this field, press F16 (Remove edit). Note that F16 removes all editing values defined in all four edit options, not just this option.

For the Edit word prompt, either you must specify an edit word or you must press F12 to return to the Define Numeric Field Editing display. You cannot leave the Edit Word prompt blank.

If an error occurs while a field is being edited by Query, the field is edited with the J edit code, and the field value is displayed in its edited form along with an error message.

Edit word in Query for iSeries reports

Type the character string that you want used as the edit word for this field. The character string must be enclosed in quotation marks and the number of blanks the edit word contains must equal the number of digits in the field, as determined by the length field shown on the display. Insert a zero or asterisk as the first character of the edit word to prevent the truncation of leading zeros.

For example, if your edit word is

’0 / / ’

the value of 01251960 becomes 01/25/1960. Without a leading zero or asterisk, 01251960 would appear as 1/25/1960. To specify a blank space in the report result, use an ampersand (&).

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