loading .d files

[shwems]

Hi evryone, i am not sure to post to the right place,

here is my problem :

i usually load .d files throught the menu tools => data dictionnary
then on the next menu => load Data & Definition => Table content (.d file)

I need to execute this as batch, with going in the "graphical" interface

I try with a 'proutil' command line like :

proutil db/kmcom -C load ori/action.d -TM 31 -TB 31 -T /var/tmp

but i take the following error


Error reading header from file ori/action.d, errno = 0. (6155)
Binary Load failed. (6255)


I can't find anything (Progress is very new for me) about that, so

1°) Can it be possible to load .d file into progress in batch mode ?

2°) If it can be done, could give me some exemple please

Thanks

shwems

 

[TomBascom]

Proutil load is a binary load routine. It expects binary dump files that were created by proutil dump.

To load plain .d files you need to use the prodict routines by writing a "stub" .p like this:

/* loaddat.p */

run prodict/load_d.p ( "all", "directory" ).

(FYI prodict/load_d.p can be found in $DLC/src/prodict.pl)

and then running from a command line like this:

pro -p loaddat.p

You can, of course, get fancy and pass in table names and such with -param if you want.

 

[shwems]

Thank you very much, i was looking on progress doc for solution (i was searching in Progress Software Knowledge Center for that) and i found the solution you gave to me.

May i ask u too how to use -param option please ... ?
I have about 12 .d files to load, but i dont know how to use the param option

Thanks By advance

Load will be lauch by a perl batch as :

my @datafiles = glob ("ori/*d");
foreach my $dfiles(@datafiles)
{
print "Loading $dfiles\n";
#here i ll execute the progress execute line with -param option
print "\n";
}

Option should be take the file name

Shwems

 

[TomBascom]

/* loaddat.p */

run prodict/load_d.p ( session:parameter, "directory" ).

pro -p loaddat.p -param tableName

 

[shwems]

Thank u very much for your help

 

[TomBascom]

You're welcome. Feel free to click on the "karma" button :awink:

 

[shwems]

Sorry but what is the "karma" button ?

 

[TomBascom]

Look in the upper right hand corner of the box surrounding a post... It's a black & white circle with the word "karma" in small print. When someone answers a question or posts something helpful you click it and stroke their ego a bit. Or you can just wire funds

 

[Barttrump]

Is it possible to change the "Acceptable Error Percentage" when loading d-file in batch or when using run prodict/load_d.p?

Thanks