Question Loading DF (.df's) File in Progress via Proenv or cmd

Malaiyappan

New Member
loading database definitions (.df's) using Proenv or cmd, This is needed to be automated hence we are using this to load the DF,

In Ex: Data definitions (.df) needs to be load using newly created df.

The Progress DB Version 11.7.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
 

Malaiyappan

New Member
Thanks for you response !

I just need to run the DF using Proenv , cmd or procedure.
I don't want use the Data Administration toll to do this.

While running the .p
RUN D:\Backup\test\load.p ("D:\Backup\test\sports.df,yes").

Error:
Procedure:%location%\p89758.ped passed
Parameter to %location%\load.p, which didn't expect any.(1005)

The simple method i need to run the newly created df using proenv or cmd.
 

Cringer

ProgressTalk.com Moderator
Staff member
Look into using Apache Ant and more specifically PCT. Very simple to build automated scripts that way.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
Thanks for you response !

I just need to run the DF using Proenv , cmd or procedure.
I don't want use the Data Administration toll to do this.

While running the .p
RUN D:\Backup\test\load.p ("D:\Backup\test\sports.df,yes").

Error:
Procedure:%location%\p89758.ped passed
Parameter to %location%\load.p, which didn't expect any.(1005)

The simple method i need to run the newly created df using proenv or cmd.
What is "load.p"?
 

Malaiyappan

New Member
The load.p contains the same as below.
RUN D:\Backup\test\load.p ("D:\Backup\test\sports.df,yes").
/*
Input Parameters:
df-file-name : sports.df
*/
 

Malaiyappan

New Member
ok can you you provide the steps to load DF via proenv or cmd without Data Administration.
else how the .df can be loaded by passing the Data Administrator tool.
 

Rob Fitzpatrick

ProgressTalk.com Sponsor
ok can you you provide the steps to load DF via proenv or cmd without Data Administration.
else how the .df can be loaded by passing the Data Administrator tool.
You need to write a wrapper procedure for the dictionary (prodict) load program. Did you read the articles I posted above?
 

Malaiyappan

New Member
Yes, I read you previous commands.
There are two option to load the /* dump.p */ and /* load.p */.
It's kind of 2 program Incremental from existing backup and dump.
I need to load newly created .DF needs to be loaded via proenv or cmd etc..
 

TomBascom

Curmudgeon
The wrapper that Rob is referring to and that the linked kbase entries show is similar to this:

Code:
/* loaddf.p
 *
 */

run prodict/load_df ( input session:parameter ).

return.

(I prefer the version above because you can pass the .df file name as a parameter rather than hard-coding it.)

To use this from a proenv command:

Code:
proenv>  pro dbname -p loaddf.p -param dbname.df
 

Malaiyappan

New Member
Great, Finally the script was worked as below.

mpro -b -db C:\database\sports\sport.db -p E:\loaddf\load.p -param ("E:\loaddf\sports.df").
 

TomBascom

Curmudgeon
The parenthesis and period should not be part of your command line. In other words, you should be executing:

Code:
mpro -b -db C:\database\sports\sport.db -p E:\loaddf\load.p -param "E:\loaddf\sports.df"
 
Top