Kbase P103504: How to load definitions into the database from within your application
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/16/2010 |
|
Status: Verified
GOAL:
How to load definitions into the database from within your application
GOAL:
Can the regular Dictionary and Admin tool load utilities be called from within your application?
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
FIX:
To load schema definitions into a database without using the regular dictionary or admin load utilities, run prodict/load_df.p. This procedure takes one input parameter but it can contain multiple entries. The entries are positional and must be in the correct order.
If user wants to load new tables and sequences on-line and commit with errors than the parameter must have three entries, "<df file name>,<commit>,<session parameter>". If not committing with errors but loading on line, there must be a blank entry between the first and third entry see example 2 below.
If user wants to commit even if there are errors in the df, they can pass in a string composed of two entries "<df file name>,yes".
Else just the <df file name> is passed in.
Example:
Commit with errors and loading on-line = "sports.df,yes,NEW OBJECTS"
Do not commit with errors and loading on line = "sports.df,,NEW OBJECTS"
Just passing in file name "sports.df".