Exit This Query

 

Type choices, press Enter.

 

 

 

Save definition . . .

Y

Y=Yes, N=No

Run option

1

1=Run interactively

 

 

 

2=Run in batch

 

 

 

3=Do not run

For a saved definition:

 

 

 

Query

KJOQRY

Name

 

Library

YOURLIB

Name, F4 for list

Text

. . . .

Lists customer names and addresses

Authority

*CHANGE

*LIBCRTAUT, *ALL, *CHANGE,

 

 

 

*EXCLUDE, *USE

 

 

 

authorization list name

F4=Prompt

F5=Report

F13=Layout

F14=Define the query

11.Press the Enter key to save the query definition object and run the query. The report produced by the query is shown on your display:

 

 

 

 

 

Display Report

 

 

 

 

 

 

Query .

. . :

YOURLIB/KJOQRY

 

 

 

Report width

 

. . . . .

:

117

 

Position to (Line) .

.

. . ______

 

Shift to column

 

. . . . .

.

_____

 

Line

....+....

1....

+

....2....

+....

3....

+....

4....

+....

5

....+....

6....

+....

7...

 

LASTNAME

 

 

FIRSTNAME

ADDRESS1

 

 

 

ADDRESS2

 

 

 

000001

SIMPSON

 

 

FRANK

 

1722

ORANGE STREET

 

 

 

 

 

000002

DAYE

 

 

BEN

 

1312

ELM STREET

 

 

APT C

 

 

 

000003

SEDGEWICK

 

 

LILLIAN

 

200 PARK LANE

 

 

 

 

 

 

000004

LIEN

 

 

SUE

 

469 JACKSON STREET

 

 

 

 

 

000005

PATTERSON

 

 

TAMMY

 

4 RIDGEVIEW COURT

 

 

 

 

 

000006

SKOGGEN

 

 

LINDA

 

CIRCLE COURT NE

 

 

 

 

 

 

000007

SEDGEWICK

 

 

LEONA

 

21ST CANNERY ROW

 

APT 43

 

 

 

000008

BARKER

 

 

RICK

 

1432

LE GRAND BLVD

 

 

 

 

 

000009

GOLINERO

 

 

SEBASTIN

7196

THOMAS STREET

 

 

 

 

 

000010

SKOGGEN

 

 

CHARLES

 

401 ABBEY ROAD

 

 

 

 

 

 

****** ********

End of report

********

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Bottom

 

F3=Exit

F12=Cancel

 

F19=Left

F20=Right

F21=Split

 

F22=Width

 

 

The report lists all the information in the file NAMEADDR. The data, including column headings, was defined to the system using IDDU.

Press F20 (Right) to see the right side of the report.

12.Press F3 (Exit). The Work with Queries display is shown.

A message is shown on the bottom of the display confirming that the query was processed successfully.

210Query for iSeries Use V5R2

Page 222
Image 222
IBM SC41-5210-04 Change LIBCRTAUT, *ALL, *CHANGE EXCLUDE, *USE, Simpson Frank, Daye BEN, Apt C, Lillian Park Lane, Linda