Table 10. How CCSIDs Affect Displaying a Query
Job CCSID
Query CCSID
Constants Processed as Marked
with CCSID
37
37
37
65535
37
37
37
65535
65535
65535
No tag
65535
37
No tag
65535
Changing a Query for iSeries query
You can change the query definition if the process (job) CCSID and the query definition CCSID match, if
either is marked with a CCSID of 65535 (do not convert), or if the query definition is not marked.
Table 11 shows when a query can be changed and how the constants are treated.
Table 11. How CCSIDs Affect Changing a Query
Job CCSID
Query CCSID
Constants Processed as Marked
with CCSID
37
37
37
65535
37
37
37
65535
37
65535
No tag
65535
37
No tag
37
37
500
Cannot change
Getting a list of objects with text in Query for iSeries
No conversion is done when query gets text descriptions for queries, translation tables, files, or libraries
because these text descriptions cannot be marked with a CCSID.
If the descriptive text is not displayed in a list display, press F11.
Defining a Query for iSeries query
You may see CCSID related diagnostic messages in a definition you are either creating, changing, or
displaying. See “CCSIDs and Query for iSeries query definition items” on page 252 for more information.
Defining a collating sequence in Query for iSeries
If a collating sequence CCSID does not match your job CCSID and neither CCSID is 65535, the collating
sequence CCSID is converted to your job CCSID before the Define Collating Sequence display is
initialized. If a translation table cannot be converted, it is not used, regardless of the choice in the
Ignore
character substitution
prompt.
If you are creating or changing a collating sequence and select option 3 on the Select Collating Sequence
display, Query for iSeries assumes that you are starting work on a new sequence. Query for iSeries looks
at the following list and selects the first existing sequence that either requires no conversion or can be
converted (without character substitution) to your job CCSID.
v
The previously defined sequence for this query
v
The user-defined default sequence from the query-user’s profile
v
The language sequence for your system
v
The hexadecimal sequence
250
Query for iSeries Use V5R2
Содержание @server iSeries
Страница 1: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Страница 2: ......
Страница 3: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Страница 12: ...x Query for iSeries Use V5R2 ...
Страница 14: ...2 Query for iSeries Use V5R2 ...
Страница 18: ...Figure 3 Major Tasks on the Query Menu and the Work with Queries Display 6 Query for iSeries Use V5R2 ...
Страница 32: ...20 Query for iSeries Use V5R2 ...
Страница 38: ...26 Query for iSeries Use V5R2 ...
Страница 44: ...32 Query for iSeries Use V5R2 ...
Страница 116: ...104 Query for iSeries Use V5R2 ...
Страница 122: ...110 Query for iSeries Use V5R2 ...
Страница 146: ...134 Query for iSeries Use V5R2 ...
Страница 150: ...138 Query for iSeries Use V5R2 ...
Страница 174: ...162 Query for iSeries Use V5R2 ...
Страница 178: ...166 Query for iSeries Use V5R2 ...
Страница 196: ...184 Query for iSeries Use V5R2 ...
Страница 198: ...186 Query for iSeries Use V5R2 ...
Страница 204: ...192 Query for iSeries Use V5R2 ...
Страница 205: ...Part 4 Appendixes Copyright IBM Corp 2000 2002 193 ...
Страница 206: ...194 Query for iSeries Use V5R2 ...
Страница 210: ...198 Query for iSeries Use V5R2 ...
Страница 242: ...230 Query for iSeries Use V5R2 ...
Страница 256: ...244 Query for iSeries Use V5R2 ...
Страница 270: ...258 Query for iSeries Use V5R2 ...
Страница 272: ...260 Query for iSeries Use V5R2 ...
Страница 292: ...280 Query for iSeries Use V5R2 ...
Страница 293: ......
Страница 294: ... Printed in U S A SC41 5210 04 ...