Kbase P101286: Generate Delta SQL Utility is different from migration utility when defining format for char field w
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/03/2005 |
|
Status: Verified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
Generate delta SQL utility is different from the migration utility when defining format for char field when using width option
Select using width field in both migration and delta SQL
For a char field defined as format x (5), the migration creates it as FORMAT x (5) and VARCHAR2 (10) in Oracle
For the same char field defined as format x (5), the delta SQL creates it as FORMAT x(10), and VARCHAR2(10) in Oracle.
CAUSE:
The migration utility goes through fix up (adjust schema) process which changes the FORMAT, the delta SQL does not go through the process, so the FORMAT is not changed. This is expected behavior
FIX:
Manually modify the FORMAT in delta df or
1. Load delta df into schema holder
2. Connect to both progress database and schema holder, run adjust schema