Kbase 20323: Problems Load a .dbf File into a Version 9.x Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/7/2011 |
|
Status: Verified
SYMPTOM(s):
Can't load .dbf file into Progress 9.x database
Error when loading .dbf into Progress 9.x database
Error:
Load Terminated
Error occured during load. Press OK to back out transactions.
FACT(s) (Environment):
Progress 9.x
CAUSE:
The problem is caused by the incorrect format of the .df file created by the dbf utility (dbf.exe). The code "ON <filename>" is missing from the .df. The dbf.c file has not been updated since Progress 7.x, but the dump utilities have changed, thus the format of the file is now incorrect.
FIX:
There are two workarounds for this problem:
Option 1: Rename the dbf executable to dbf.v6 and write a script named
"dbf":
# This script is a wrapper for a Progress dbf executable.
# It corrects the .df format, allowing a load into a Version
9.x database.
# Rename the Original dbf executable to dbf.v6
dbf.v6 "$@" | \
awk '
BEGIN {
getline
if($0 ~/^CREATE FILE/) OfTable=" OF " $3
print
}
/^ADD FIELD/ {$3=$3 OfTable; print; next}
{print}'
The script changes the .df format in the way that allows it to
load into a Progress 9.x database. It does not change dbf's
output produced with other options.
Option 2: If the database files are loaded into a Progress 8.x database,
dump the .df file and edit it. Add AREA "Schema Area" to the
file. The file can now be loaded into a Progress 9.x database via the Data Administration tool.