IBM SC41-5210-04 Copying a Query for iSeries query definition, Acctrecfeb Inventfeb Mailaddr

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.

	ColSeq=YES Unique	ColSeq=YES Shared	ColSeq=NO Unique	ColSeq=NO Shared
Test	Weights	Weights	Weights	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:

vTo copy a query from someone else’s library into your library.

vTo 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.

vTo copy a query so that you can change it without changing the original.

vTo 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