Filter
Top Products
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.
210 Query for iSeries Use V5R2