Kbase 19041: PROTOORA Changed Table/Field Names And Added Integer Field Within Schema Holder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/06/2003 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
After running PROTOORA, table and field names have been changed within from XXXX to XXXX_ within the schema holder.
After running PROTOORA, there is an additional INTEGER field for DATE fields; "<date_field_name>-1
CAUSE:
Within the Progress .df, the FOREIGN-NAME value is to "n/a". Upon a migration from Progress to Oracle, the value should be "?", NULL.
FIX:
The solution is to change the value of _File._For-Name and/or _Field._For-Name to "?" . This will preserve its original name and avoid creating a field for the INTEGER (TIME part) for the Date column.