Filter
Top Products
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