IBM SC41-5210-04 manual Displaying the format of constants in Query for iSeries, QRY1, Qgpl Ccsid

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:

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

vYou must have the authority needed to use the library containing the query definition.

vThe 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:

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

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

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

vUse 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