Kbase P144416: 4GL/ABL: What is the syntax for calling the prodict/dump_df.p procedure to dump ONE database table
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/25/2010 |
|
Status: Verified
GOAL:
4GL/ABL: What is the syntax for calling the prodict/dump_df.p procedure to dump ONE database table data definitions (.df)?
GOAL:
How to call the prodict/dump_df.p procedure to dump MULTIPLE table data definitions (.df)?
GOAL:
How to invoke the prodict/dump_df.p procedure to dump ALL the tables' data definitions (.df) of the connected database?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
FIX:
The syntax for calling the prodict/dump_df.p procedure is:
RUN prodict/dump_df.p(INPUT file-name, INPUT df-file-name, INPUT code-page).
Where:
file-name = "TableName" to dump ONE table data definitions, OR "ATable,BTable,CTable..." to dump MULTIPLE tables' data definitions OR "ALL" to dump all the tables' data definitions.
df-file-name = The name of the .df file to dump to.
code-page = ? If no-conversion is desired OR "" if default conversion (SESSION:STREAM) is desired OR "<code-page>" if conversion to a specific code-page is desired. Examples:
1. The following statement dumps the data definitions for ONE table, the customer table without conversion:
RUN prodict/dump_df.p
(INPUT "Customer",
INPUT "SingleTableDumpTargetFileName.df",
INPUT ?
).
2. The following statement dumps the data definitions for two tables, the customer and order tables with default code page conversion to the SESSION:STREAM:
RUN prodict/dump_df.p
(INPUT "Customer,Order",
INPUT "MultipleTablesDumpTargetFileName.df",
INPUT ""
).
3. The following statement dumps the data definitions for all the specified database tables with code page conversion to the ibm850 code page:
RUN prodict/dump_df.p
(INPUT "ALL",
INPUT "AllTablesDumpTargetFileName.df",
INPUT "ibm850"
).