Filter
Top Products
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:
v One with unique weights for each character in the table.
v One 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