View Single Post

   
  #4 (permalink)  
Old 04-10-2008, 12:02 AM
Scott Auge
 
Posts: n/a
Default Re: Automatic dump and load of a database.

In article <mn.e2577d5b8667e1c4.34768@meil.com>,
"Andre Georgel" <nospam@meil.com> wrote:

> Andre Georgel avait énoncé :
> > Hi all,
> >
> > I want to make a procedure to dump and load automatically a database.
> >
> > I will use the progress procedures dump_df, dump-d, load_df, load_d but it
> > seems I've a "big" problem with the environnment variables.
> >
> > Hereafter, my procedure :
> > /* Début */
> > PAUSE 0 BEFORE-HIDE.
> > RUN dump_df.p (INPUT "ALL", INPUT "acces.df", INPUT "ibm850").
> > RUN dump_d.p (INPUT "ALL", INPUT "", INPUT "ibm850").
> > DISCONNECT acces.
> > UNIX rm acces.db SILENT.
> > UNIX rm acces.bi SILENT.
> > UNIX rm acces.lg SILENT.
> > UNIX prodb acces empty SILENT.
> >
> > CONNECT acces -1 -i.
> >
> > RUN load_df.p (INPUT "acces.df").
> >
> > RUN load_d.p (INPUT "ALL", INPUT "acces/").
> >
> > /* Fin */
> >
> > OS is UNOX SCO Openserver 5.06 with Progrese V 7.3E (it is old, I know, but
> > it run fine . . .)
> >
> > The PROPATH variable contain /appli/dlc/src/prodict
> >
> > At execution i've the message "dump_df not found". If i give the full pat
> > fo
> > dump_df.p, i've another error "not found" message for other included
> > procedures : prodict/user/uservar.i, prodict/dictvar.i etc...
> >
> > can somebody give me where is my error ?
> >
> > tnak you in advance for the answers.
> >
> > André Georgel

>
> Error, the varaible containing /appli/dlc/src/prodict is the UNIX PATH.


Is the script that runs the above program calling Progress with the DLC
variable set to the location of the Progress. For example - what I do
is something like:

#!/bin/bash
# Which version of progress are we using?

#export DLC=/opt/prg91c
#export DLC=/opt/prg91d
export DLC=/opt/prg91e

$DLC/bin/mpro -pf /db/prod/dbname/server.pf -p myprogram.p

If the DLC is set, all the goodies needed by the dictionary routines
should automatically be set up. The PROPATH is really to aid Progress
in finding myprogram.p.




--
Available for Hire! http://amduus.com/Resumes/
Reply With Quote