Kbase 19296: ORACLE Dsrv: Is there a difference on how shadow columns are
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/15/2003 |
|
Status: Verified
GOAL:
Is there a difference on how shadow columns are implemented in Progress 8.3B versus Progress 8.2x
GOAL:
Migrating to Progress 8.3B and later, shadow columns are blank if compile is not done
FACT(s) (Environment):
Progress 8.2x
FACT(s) (Environment):
Progress 8.3x
FACT(s) (Environment):
Oracle DataServer
FIX:
Oracle DataServer uses shadow columns to support case-insensitive indexes. When a Progress database is migrated to Oracle, Progress creates shadow columns (named U##column-name) to the character indexed columns to provide the case insensitivity.
When migrating within releases (8.2x to 8.3B), there is never a need to recompile code. The exception to the rule is when migrating from a Progress 8.2x/8.3A to Progress 8.3B (& later).
When migrating within releases on or after Progress 8.3B, a recompile is necessary and if not performed, the shadow columns will not be updated.