Kbase 20925: ORACLE: SQL-WIDTH Not Considered for Delta.df/.sql
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Verified
GOAL:
How to use SQL-WIDTH during the creation of a delta.df/.sql file
FACT(s) (Environment):
Oracle DataServer
Progress 9.1A
Progress 9.1B
Progress 9.1C
FIX:
SQL-WIDTH option is included in migration utility to give users option to use SQL-WIDTH as display length, but this option is not included in delta sql progress to Oracle utility.
In order to achieve the same result, you will have to manually edit the delta.df and delta.sql file that is created by Progress delta migration to reflect correct field size.
This is specific for all "new tables/columns" that are created within a Progress database, because Progress does not change the field size in ORACLE with the incremental process.
Upgrade to 9.1D will also give you the option to use SQL-WIDTH.