Filter
Top Products
Table 8. Effect of Collating Sequence and Processing Option on Selection. Either or both NAME1 and NAME2 are
DBCS data. Yes means the record under test is selected. No means it is not selected.
Test
ColSeq=YES Unique
Weights
ColSeq=YES Shared
Weights
ColSeq=NO Unique
Weights
ColSeq=NO Shared
Weights
NAME1 EQ NAME2 No Yes No No
NAME1 GE NAME2 Yes Yes Yes Yes
NAME1 GT NAME2 Yes No Yes Yes
NAME1 NE NAME2 Yes No Yes Yes
NAME1 LE NAME2 No Yes No No
NAME1 LT NAME2 No No No No
Copying a Query for iSeries query definition
There are many reasons for copying a query. Following are some of the most common:
v To copy a query from someone else’s library into your library.
v To copy a query you keep in a test library for experimenting with different files, record formats, and
query features. When you have a query you want to use, you can copy it into your library and keep the
original in the test library for further experiments.
v To copy a query so that you can change it without changing the original.
v To rename a query or move a query to another library by copying the query to the other library and then
deleting the query from the original library.
You can copy a previously saved query by using option 3 (Copy) on the Work with Queries display. You
can type the name of the query (and its library) on the display, or you can, from a list of queries, type a 3
next to the query(s) that you want to copy. (For more information about using lists, see “Using lists in
Query for iSeries” on page 9.)
After you press the Enter key, the Copy Queries display appears. (The following display has some sample
information typed in.)
Copy Queries
From library ......: TESTLIB
Type choices, press Enter.
To library ....... __________ Name, F4 for list
Replace query...... N Y=Yes, N=No
To rename copied query, change To Query name.
From Query To Query
ACCTRECFEB __________
INVENTFEB __________
MAILADDR __________
PAYROLLFEB __________
F3=Exit F4=Prompt F9=Reset F12=Cancel
F20=Cancel copy in error
To place the copy in a library other than the library that contains the original query, type a different library
name in the To library prompt. If you do not know the name of the library that should receive the copy, you
can use F4 (Prompt) to select a library from a list.
Chapter 16. Working with Query for iSeries query definitions 177