Kbase 16312: AS/400 ALTSEQ tables with DUPPRODB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/27/2004 |
|
Status: Unverified
GOAL:
A list of ALTSEQ tables for collation and case conversion.
FACT(s) (Environment):
AS/400
SYMPTOM(s):
Creating the server schema with DUPPRODB command.
FIX:
Depending on the code page you are using you need to use ALTSEQ tables
for the collation and case conversion when creating the server schema
with DUPPRODB command.
Normally you will want to use for your database the same code page that the OS/400 operating system is using as default (*SYSVAL). To know which code page is using your operating system you can use the command:
DSPSYSVAL QCHRID
Once you know the code page you want to use, you can use the following
standard ALTSEQ tables when using DUPPRODB command:
Case Case Upper
code page Country sensitive insensitive case
-------- ------- --------- ----------- -----
037 USA QLA10025U QLA10025S Q037 *
037 Canada QLA10025U QLA10025S Q037 *
256 Netherland QLA10100U QLA10100S Q256 *
273 Germany QLA10111U QLA10111S Q273 *
273 Austria QLA10111U QLA10111S Q273 *
277 Norway QNOR0115U QNOR0115S Q277
277 Denmark QDAN0115U QDAN0115S Q277
278 Sweden QSNF0116U QSNF0116S Q278
278 Finland QSNF0116U QSNF0116S Q278
280 Italy QLA10118U QLA10118S Q280 *
284 Spain QLA1011CU QLA1011CS Q284 *
284 Spain QESP01F4U QESP01F4S Q284
285 UK QLA1011DU QLA1011DS Q285 *
297 France QLA10129U QLA10129S Q297 *
420 Arabia QARA01A4U QARA01A4S Q420
870 Latin 2 QLA20366U QLA20366S Q870 *
1026 Turkey QTRK0389U QTRK0389S QA3S
Multinational 500 code page:
500 Denmark QDAN01F4U QDAN01F4S Q500
500 Latin 1 QLA101F4U QLA101F4S Q500 *
500 Norway QNOR01F4U QNOR01F4S Q500
500 Spain QESP01F4U QESP01F4S Q500
500 Sweden QSNF01F4U QSNF01F4S Q500
500 Finland QSNF01F4U QSNF01F4S Q500
The tables marked with * are using Latin collation. This collation is
very similar to the one used by MS Windows clients, so it is a very
good way to get rid of the ASCII-EBCDIC conversion problems.
Note that the lower case table must be built manually because IBM does
not provide it. This table is used when you use the LC function in a
query which must be resolved by the server. Consult your IBM
documentation on how to build this table.