Kbase P101296: delta sql utility does not behave consistently as migration utility when defining number arrays
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/05/2006 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0B
Oracle DataServer
SYMPTOM(s):
delta sql utility does not behave consistently as migration utility when defining number arrays
Select using width field in both migration and delta sql
For a number array, the migration creates it as NUMBER (18,6) in Oracle
For the same number array, the delta sql creates it as NUMBER(140,6) in Oracle.
The sql-width is 140
The table has been renamed (dropped and recreated)
CAUSE:
This is a known issue being investigated by Development
FIX:
Upgrade to 10.0B02 or latest