IBM SC41-5210-04 manual Selecting a system sort sequence in Query for iSeries

	Select Translation Table
Library . . . .	. . . . *LIBL	Name, *LIBL, F4 for list
Subset . . . .	. . . . __________	Name, generic*
Position to . .	. . . . __________	Starting character(s)
Type option (and Table and Library), press Enter.
1=Select
Opt Table	Library Text

___________ _________

_	QASCII	QSYS	EBCDIC TO ASCII TRANSLATE TABLE
_	QEBCDIC	QSYS	ASCII TO EBCDIC TRANSLATE TABLE
_	QLA10025S	QSYS	LATIN1 CCSID 37 SHARED WEIGHTED
_	QLA10025U	QSYS	LATIN1 CCSID 37 UNIQUE WEIGHTED
_	QRMASCII	QSYS	EBCDIC TO ASCII TRANSLATE TABLE FOR RM/COBOL
_	QRMEDCDI	QSYS	ASCII TO EBCDIC TRANSLATE TABLE FOR RM/COBOL
_	QSYSTRNTBL	QSYS	LOWER TO UPPER CASE TRANSLATE TABLE
_	QA3BA69A3R	QUSRSYS	CHRID(*N 1009) TO CHRID(1150 1025) TRANSLATE

More...

F4=Prompt	F11=Display names only F12=Cancel
F19=Next group

For more information on using lists, see “Using lists in Query for iSeries” on page 9.

Selecting a system sort sequence in Query for iSeries

You can specify that the query use a system-provided sort sequence associated with a specific language. There are two sort sequences for each language:

vOne with unique weights for each character in the table.

vOne with shared weights for various characters.

Note: The system provides the system sort sequences as translation tables in library QSYS. You can also select them by name using option 4 (Translation table) on the Select Collating Sequence display.

The system sort sequences are different than the Query for iSeries language sequences (option 2 on the Select Collating Sequence display). The Query for iSeries language sequences are not externalized objects and can only be used with Query for iSeries definition objects. Also, the Query for iSeries sequence for a language does not produce the same results as either of the system sort sequences for that language. For the differences in your language, check the sequence tables. Often, the difference is where the number characters are sorted.

To display the Select System Sort Sequence display select option 5 on the Select Collating Sequence display and press the Enter key.

Note: In addition to 2(Unique) and 3(Shared) you can specify *HEX or a specific table with the SRTSEQ parameter for your job.

Chapter 9. Selecting a collating sequence in Query for iSeries 117