IBM ISERIES SC41-5210-04 - Manual (Page 29)

Other considerations when you are trying to locate or use a particular Query for
iSeries 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 iSeries
query” on page 168.
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 iSeries
If you create or change a query and specify a date or time constant in an OS/400 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 OS/400 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 either at least one date or time constant is
specified in the query definition in an OS/400 format other than the date or time format 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 OS/400 date or time format constant that is specified in the query definition.
v Use the run-time record selection option of the RUNQRY command and your job format for the date
or time is different from an OS/400 date or time format constant specified in the query definition.
v Use the run-time record selection option with the QRYRUN procedure and your job format for the date
or time is different from an OS/400 date or time format constant specified in the query definition.
Chapter 2. General operating information for Query for iSeries 17