If there are multiple libraries the queries are

If there are multiple libraries, the queries are listed in alphabetical order
within each library. The libraries themselves are shown in alphabetical order if *ALL , *ALLUSR , or a
generic library name is specified. If you specify *LIBL or *USRLIBL , the libraries are shown in the order
that they are listed in the library list.
If you specify a library name or special value that contains no query definitions (or none that you have
authority to use), a message is displayed indicating there were no queries.
If the list of queries is not empty but one of the libraries in the group is being used or is damaged, a
message is displayed indicating that the list may be incomplete.
v Move the cursor to the Library prompt and either leave the prompt blank or type a generic name or a
special library name, then press F4 to list the libraries. A list of the libraries that you are authorized to
use is shown.
16
Query for i5/OS V6R1

Other considerations when you are trying to locate or use a particular Query for
i5/OS query
You should be aware of other considerations when you are trying to locate or use a particular query. To
use a query:
v You must have the authority needed to use the query definition. You may need to either ask the owner
of the query, the administrator, or security officer to give you the type of authority that is necessary.
For more information about the types of authority, see “Giving authority to others to your Query for
i5/OS query” on page 166.
v You must have the authority needed to use the library containing the query definition.
v The query (or the library) must not be in use in such a way that it cannot be shared. For example, if
the owner is making changes to the definition of the query or if the system operator is saving the
library that contains the query, you may need to wait a short time before you can use the query. If the
Text and Changed columns are blank in a query list with the text displayed, the query is being used.
Displaying the format of constants in Query for i5/OS
If you create or change a query and specify a date or time constant in an i5/OS format or a numeric
constant with a decimal separator, that format must match the format description or separator shown on
the Display Constants Format display. To check what i5/OS format or separator you must use, press F17
from either the Select Records display or the Define Result Fields display.
Note: If you are sending queries between countries that use the comma for a decimal separator, put a
blank after each comma separating arguments in a function, such as SUBSTR or VALUE.
Display Constants Format
Query . . . . . . : QRY1 Option . . . . . : CHANGE
Library . . . . : QGPL CCSID . . . . . . : 65535
Use an SAA format to enter a date or time constant, or
use the format described by the following values.
Use the decimal separator shown.
Query definition values
Date format . . . . : *MDY
Date separator . . : /
Time format . . . . : *HMS
Time separator . . : :
Decimal separator . : .
Press Enter to continue.
F12=CANCEL
The Display Constants Format display appears when you:
v Change a query from the Work with Queries display and at least one date or time constant is specified
in the query definition in an i5/OS format other than the date or time format that is specified for your
job.
v Display a query from the Work with Queries display and your job format for the date or time is
different from an i5/OS date or time format constant that is specified in the query definition.