IBM ISERIES SC41-5210-04 User Manual

Page 202

Example: Increasing the decimal precision for result fields in Query for
iSeries

Figure 5 has a result field with a current maximum precision of 31 (length) and 2 (decimal positions). The
decimal precision was derived from the calculation 31-29+9-9.

Note: The presentation length for RESULTA a would be 31,9. You can see this by pressing

″F13=Layout″.

To increase the decimal precision for the result field (RESULTA):

1. Assign each input field (PRN299A, PRN299B) directly to a result field.

2. Replace the input fields used in the original result field expression with the new result fields

(RESULT269, RESULT295).

3. Change the corresponding length (Len) and decimal positions (Dec) for the new result fields so that

the decimal precision sufficiently increases (see the previously listed formulas) for the original result
field (RESULTA).

In Figure 6 on page 191the RESULTA decimal precision is changed from 2 to 9. The new decimal
precision was derived from the calculation 31-26+9-5.

Define Result Fields

Type definitions using field names or constants and operators, press Enter.

Operators: +, -, *, /, SUBSTR, ||, DATE...

Field

Expression

Column Heading

Len

Dec

RESULTA___ PRN299A/PRN299B__________________ ____________________

_________________________________ ____________________

__________ _________________________________ ____________________

_________________________________ ____________________

__________ _________________________________ ____________________

_________________________________ ____________________

Bottom

_______________________________________________________________________________

Field

Text

Len Dec

PRN299A

Field with precision of 29,9

PRN299B

Field with precision of 29,9

Bottom

F3=Exit

F5=Report

F9=Insert

F11=Display names only

F12=Cancel

F13=Layout

F20=Reorganize

F24=More keys

Figure 5. Decimal Precision Using Default

190

Query for iSeries Use V5R2