Kbase 16446: ALTSEQ tables: Where are they stored
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/9/2005 |
|
Status: Unverified
GOAL:
AS/400 ALTSEQ tables: Where are they stored?
FACT(s) (Environment):
Progress AS400 Dataserver
FIX:
It is important to be sure of what ALTSEQ tables were used when the database was created.
The ALTSEQ tables supplied in the DUPPRODB command when creating a *PROEMPTY database are stored in the P__DB file. To look at them, run the following code on a client session having connected the schema holder and AS/400 database:
FIND FIRST P__DB NO-LOCK.
DISPLAY _DB-collate[1] LABEL "Case Sensitive " FORMAT "X(30)"
_DB-collate[2] LABEL "Case Insensitive" FORMAT "X(30)"
_DB-collate[3] LABEL "Upper case " FORMAT "X(30)"
_DB-collate[4] LABEL "Lower case " FORMAT "X(30)"
_DB-xl-name LABEL "Codepage " FORMAT "X(30)"
WITH 1 COL.