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:

vLast name

vFirst name

vAddress 1

vAddress 2

vCity

vState

vZip code

206Query for iSeries Use V5R2

Page 218
Image 218
IBM SC41-5210-04 manual =Yes, N=No