Kbase 18554: How To Remove Area Names To Load A DF File In V9
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
How to Remove Area names to load a df file in V9
GOAL:
Removing Area names to load a df
FACT(s) (Environment):
Progress 9.X
CAUSE:
With the introduction of AREA's in version 9 of Progress came a simple but time-consuming issue for TSE's trying to reproduce customer issues.
Many times when attempting to reproduce a customer issue we ask for a customer's .df file so that we can load it into an empty database and attempt to duplicate their issue against a specific set of definitions.
This issue concerns the fact that your .df will contain an entry that refers to the AREA that the table or index will be loaded into.
If the 'empty' database that you created is not created the same, the loading process of the .df will fail.
FIX:
In order to get around this problem you will need to remove ALL the entries in the definition file (.df) that make reference to AREAS.
Here is a sample .df file.
It notes the entry that TSE's will need to remove for testing customer issues:
/* Customer.df */
ADD TABLE "Customer"
AREA "Info Area" <---This is the line that we will need remove
DESCRIPTION "Customer information"
DUMP-NAME "customer"
TABLE-TRIGGER "CREATE" NO-OVERRIDE PROCEDURE "sports/crcust.p" CRC
If you do not remove ALL the lines that contain reference to AREA's you will encounter errors during the load process such as these:
** Error during ADD TABLE Customer **
AREA NAME either not found in database or not type d (data).
Removing ALL the entries in your definition file (.df) can be a time-consuming process on UNIX if you try searching and deleting each entry line by line. But using our UNIX friend 'grep', you can quickly search the file and output all the information except for those entries referencing AREA's.
In order to remove all these entries (on most UNIX systems) try the following from the UNIX command prompt:
# grep -v AREA (filename).df > (newfilename).df
This will output ALL the contents of your original definition file and redirect all the output EXCLUDING lines with the reference to AREA. You should now be able to successfully load your .df.