Help Connecting DB's from Window's Batch File

J

JimmyC

New Member
I am trying to execute a progress program from a batch file. My only problem is the program utilizes tables from two different db's .. i can connect to one with no problem, but can't seem to figure out how to get both of them connected.

Here is the command i'm using:

"C:\Program Files\PROGRESS\BIN\prowin32" "E:\apodbv6\xapp" -p "F:\commerce6\apo\ODS\runslscch2.p" -b

Thanks in advance.

Jim
 
Create a parameter file ( .pf) and use the command -pf <file-name) where you use the "E:..." . In the parameter file, put both the DB names with -H -S -ld (logical DB name).
 
And ensure that you separate them with the -db option eg:

-db db1 -N TCP -H localhost -S servicedb1 -ld ldb1
-db db2 -N TCP -H localhost -S servicedb2 -ld ldb2

Later,
Gordon
 
thanks for the help...still having a problem with the syntax of the pf file.

please be patient with me.. am very new to progress.

i have in the pf file right now:

aplusv6 -H izzodb -S aplusv6sv -N TCP -ld aplusf
xapp -H izzodb -S xappsv -N TCP -ld xapp

getting the error "Could not recognize argument: xapp. (301)

assume i'm supposed to have a [header] or DB = or something

please advise

thanks again

jim
 
OK,
here's what i have now:
-db aplusv6 -H izzodb -S aplusv6sv -N TCP -ld aplusf
-db xapp -H izzodb -S xappsv -N TCP -ld xapp

and i keep getting the error
** Your database name is longer than 11 characters. (448)

???
 
ok.. got past the db error but still have something wrong in my syntax
here's what i have:

TEST.BAT:
"C:\Program Files\PROGRESS\BIN\prowin32" -pf "C:\Documents and Settings\Administrator.MRDOMAIN\Desktop\test.pf" "F:\commerce6\apo\ODS\runslscch3.p" -b

TEST.PF:
-db aplusv6 -H izzodb -S aplusv6sv -N TCP -ld aplusf
-db xapp -H izzodb -S xappsv -N TCP -ld xapp

runslscch3.p:
RUN \\Izzodb\commerce6\apo\ODS\slscch.p ("3","-d").

i get the following error:
**Could not recognize argument: F:\commerce6\apo\ODS\runslscch3.p. (301)

thanks

jim
 
You must log in or register to reply here.
Back
Top