IBM AS/400 manual Data display appears. You can select fields, Break

Field

Name

Description

Field

Shows the

field

name

for

which

the

summary

function

is

being

Summary

Shows

the special value used to summarize

the

field

values. T

function

following

summary

function

special

values

can

be

specified

to

summary

data.

*FIRST

The

first

value

in

the

specified

field.

*LAST

The

last

value

in

the

specified

field.

*TOTAL

The total of the values

in

the

specified

field. This

data is effective for numeric fields, excluding

float

data. The

number

of

integer

digits

of

the

total

is

of integer digits of the field

plus

three. For

examp

total of the field whose integer digits are three

fractional digits are two is printed as numeric data

integer

digits

and

two

fractional

digits.

*AVG

The average of the value in the

specified

field. Th

summary data is effective for numeric fields, excludi

floating-point data.

*MAX

The

maximum

value

in

the

specified

field.

*MIN

The

minimum

value

in

the

specified

field.

*CNT

The

record

count. It

is

printed

as

8

digit

integer.

a

record

whose

field

value

is

null,

the

record

is

no

Edit

code

Specifies

the

edit

code

in

which

the

summary

data

is

pr

allowable edit codes (1-9,

A-D,

J-Q, X-Z)

and

their

printout

the same as those supported on DDS. If this parameter is no

specified, the Print Format Utility prints the field based o

information defined

by

DDS

or

IDDU

except

for

the

record

Print

Format

Utility

prints

the

record

count

with

the

leading

suppressed

by

blanks

if

an

edit

code

is

not

specified.

Edit

code

This

parameter

is

optional. It

is

effective

only

when

one

of

modifier

and

J-Q

is

specified

on

the

edit

code

parameter.

1An asterisk (*) is printed for each zero that is suppre

complete field of asterisks is printed for a zero balan

2The currency symbol defined on the system value QCURSYM i printed on the left of the first significant digit. The printed on a zero balance when an edit code is used t suppresses the zero balance.

When

you

specify

the

above parameters and press the Enter key, th

Detail

display

(or

the

Define

Box

Detail display)

appears

again.

When

you specify multiple summary dataText ondatatheprompt,

the

Select

Fields

to

Define

Summary

Data display appears. You can select fields

the

summary

function

or

specify an edit code on the display.

The

Define

Summary

Data

display appears repeatedly for each select

If

you

specify

break

fields,

you

can print the summary data for

for

each page by YspecifyingorN for Printthe at page breakpromptonly on the

Define Text Detail display (or the

Define

BoxPrintDetatil pagedisplay). The

break

onlyprompt

appears

at the bottom of the Detail display, and it

when

you

specify

break

fields. For

example,

if

you

want to

print th

SALES

field

for

each

page, specify

the

prompts as

follows:

Chapter 10.

Work

with

PFD

Definitions177