Kbase 14061: How to Dump and load .df and .d from outside the Data Administration tool?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/4/2010 |
|
Status: Verified
GOAL:
How to Dump and load .df and .d from outside the Data Administration tool?
GOAL:
How to load df files outside the Data Administration?
GOAL:
How to load d files outside the Data Administration?
GOAL:
Dumping and loading .df and .d from outside the Data Administration.
GOAL:
How to load table definitions outside of the data administration tool
GOAL:
Can ABL/4GL tables fields and indexes be created without using Data Dictionary
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
The Data Dictionary source code that Progress supplies to the customers can be used to dump or load data without running the Data Dictionary. This can be used to automate a dump and load.
The source code for Progress 6 is located in /dlc/prodict.
The source code for Progress 7 and Progress 8 is located in /dlc/src/prodict.
The source code for Progress 9 and OpenEdge 10 is in /dlc/src/prodict inside a Library file .pl.
The files are
dump_d.p - Dump table contents
dump_df.p - Dump table definitions
dump_fd.p - Dump bulkloader description file
load_d.p - Load table contents
load_df.p - Load table definitions
To access the code ...
RUN prodict/load_df.p (INPUT tablename.df).
RUN prodict/load_d.p (INPUT tablename.d, INPUT loadpath).
Parameters required by the programs are documented at the top of each program.
For more details, refer to Progress Solution 15884, "SAMPLE CODE to Dump Load .df,.d w/ Data Dictionary routines".
NOTE:
For Progress 9.x and OpenEdge 10.x , these files are contained in a .pl file, which is in the PROPATH variable by default. To get the source code, you need to extract the files following these steps:
1) Make sure that your DLC/bin directory is in your path.
2) Default to the SRC directory
3) Run the command extractpl prodict.pl
4) Run the command extractpl adecomm.pl
This will create a prodict and an adecomm directory with these files.
Progress does not provide support for the modification and/or use of these modules outside of the Data Dictionary.