IBM ISERIES SC41-5210-04 User Manual

Page 218

Advertising
background image

End Data Entry

Number of records processed

Added . . . . . :

10

Changed . . . . :

0

Deleted . . . . :

0

Type choice, press Enter.

End data entry . . . . . . .

Y

Y=Yes, N=No

You do not need to change anything on this display. Press the Enter key.

8. The Work with Database Files display is shown.

Work with Database Files

Library . . . . . . .

default__

Name,F4 for list

Position to . . . . .

__________ Starting characters

Type options (and Database file), press Enter.

1=Create

2=Enter data

Database

Database

Database

Database

Opt File

Opt File

Opt File

Opt File

F3=Exit

F4=Prompt

F5=Refresh

F11=Display text

F12=Cancel

F21=Work with definitions

F22=Work with data dictionaries

Data for file NAMEADDR in YOURLIB was changed.

A message on the bottom of the display tells you that data in your file was changed.

9. Press F3 (Exit), and you see the menu that you started from.

An audit log is automatically printed showing all the data you entered.

Query for iSeries query exercise: Creating and running a query

In the following exercise, you create and change a query that produces a report that lists all the
information in the file

NAMEADDR or any other file that may already exist on your system. NAMEADDR is a file

definition that you created in the previous example using IDDU.

NAMEADDR contains names and addresses and includes the following information:
v Last name
v First name
v Address 1
v Address 2
v City
v State
v Zip code

206

Query for iSeries Use V5R2

Advertising