The
Note: The Progress SQL-92 Engine, available in Progress 9.1 and later, does not support tableview functionality. Thus,OpenLink Data Access Drivers built for this Engine cannot support these features. The SQL-89 Engine remains a default element of all Progress 9.x installations, and appears as of this writing to be present in Progress 10.x, although Progress has announced its deprecation. OpenLink Software will continue to build and provide Drivers for the SQL-89 Engine, supporting these features and functions, as long as possible.
Once the script has been run, modify the
After installing an
setup.p setup.i oplrvc1.p oplrvc2.psetup.p is a Progress script program. When the program runs it will ask you what databases you wish to connect to. Based on your responses, it will generate a catalog of all the databases and tables found within, which will be stored in a tableview file (.dat), and an associated parameter file (.pf).
Use of these files will allow you to connect to multiple databases, see all tables in all databases through SQLTables(), and use array fields through ODBC.
Prerequisites
- Most importantly, you must have a 4GL Development System license to run this script.
Client Networking alone is not sufficient.
This script does not need to be run on the client host which will use the resulting tableview files, however -- the script may be run on any host which has the licensed 4GL Development System, and the same versions of the Client Networking libraries as will be used on the ODBC client host(s).
- Before running this program, all the databases you wish to include must be accessible -- that their database servers are running -- because the program will need to connect to them.
- Make sure that your $DLC environment variable is set correctly to point to your Progress DLC directory.
DLC=/dbs/dlc7.3E export DLC
- The PROPATH environment variable may need to include the current working directory and the directory containing the setup.p utility files.
Steps
- Navigate to the directory holding your setup.p file (~/openlink/bin/ or ~/openlink/scripts/Progress/), and execute this command --
$DLC/bin/pro -p setup.p
Note: This may vary between versions. In Progress 6, pro is in $DLC, not $DLC/bin.
- You should see the following screen:
@@@@@@ @@@@@@ @@@@@@@ @@@@@ @@@@@@ @@@@@@@ @@@@@ @@@@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@ @@@@@@ @ @ @ @@@@ @@@@@@ @@@@@ @@@@@ @@@@@ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@ @@@@@ @ @ @@@@@@@ @@@@@ @@@@@ Progress Software Corporation 14 Oak Park Bedford, Massachusetts 01730 617-280-4000 PROGRESS is a registered trademark of Progress Software Corporation Copyright 1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995 by Progress Software Corporation All Rights Reserved PROGRESS Version 7.3C as of Thu Jun 29 15:05:14 EDT 1995
- Press any key, to get to the next screen:
+-----------------------------------------------------+ | Enter a number of databases you want to connect to. | | The first database is your master database. | +-----------------------------------------------------+ +-----------------------------------------------------------------------------+ | # DbName Connect String OK| |-- ------------------------------ ---------------------------------------- --| | 1 ______________________________ ________________________________________ __| | | | | | | | | | | | | | | | | | | +-----------------------------------------------------------------------------+ Enter data or press PF4 to end.
- At this point, you will need to give the program information to contact the databases you want to include here.
First, type the full path to your Progress database.
For instance:
/users/progress/dbs/pro7test
Note: To make use of Progress Database Triggers, the Logical Database name to which the Triggers have been compiled must match the value that you provide for the -ld parameter when setting your Progress Database Connect options through setup.p.
Example:
If the triggers have been compiled against a database physically identified as /usr/progress/demo.db, and logically identified as mydemo, your setup.p Database Connection String should be:
/usr/progress/demo -ld mydemo
- Hit enter, to shift to the next field.
- If your database is running in sockets (recommended), type the -SNH parameters.
For example:
-S pro82a -N tcp -H myserver
- When you are done, hit Enter.
+-----------------------------------------------------+ | Enter a number of databases you want to connect to. | | The first database is your master database. | +-----------------------------------------------------+ +-----------------------------------------------------------------------------+ | # DbName Connect String OK| |-- ------------------------------ ---------------------------------------- --| | 1 /users/progress/dbs/pro7test__ -N tcp -H 194.152.95.26 -S pro7test_____ __| | | | | | | | | | | | | | | | | | | +-----------------------------------------------------------------------------+ Enter data or press PF4 to end.
- After entering the line of information, press return.
There will be a brief pause while the program checks that the database server is running and can be contacted.
Once verified, OK will appear at the end of the line.
+-----------------------------------------------------+ | Enter a number of databases you want to connect to. | | The first database is your master database. | +-----------------------------------------------------+ +-----------------------------------------------------------------------------+ | # DbName Connect String OK| |-- ------------------------------ ---------------------------------------- --| | 1 /users/progress/dbs/pro7test__ -N tcp -H 194.152.95.26 -S pro7test_____ OK| | | | | | | | | | | | | | | | | | | +-----------------------------------------------------------------------------+ Enter data or press PF4 to end.
- The cursor will move to the next line.
Repeat the above procedure for each database.
- Press PF4 when finished.
You will then need to supply the name for the .dat and .pf files.
The default is simply tableview, but you can choose a more meaningful name if you prefer.
If given the option to select a location for the files, pass the full path to your ~/openlink/bin/ directory.
+-----------------------------------------------------+ | Enter a number of databases you want to connect to. | | The first database is your master database. | +-----------------------------------------------------+ +-----------------------------------------------------------------------------+ | # DbName Connect String OK| |-- ------------------------------ ---------------------------------------- --| | 1 /users/progress/dbs/pro7test__ -N tcp -H 194.152.95.26 -S pro7test_____ OK| | 2 ______________________________ ________________________________________ __| | | | | | | | | | | | | | | | | +-----------------------------------------------------------------------------+ Basename for .pf and .dat files_____________________ Enter data or press PF4 to end.
- After a brief period the program will finish:
+-----------------------------------------------------+ | Enter a number of databases you want to connect to. | | The first database is your master database. | +-----------------------------------------------------+ +-----------------------------------------------------------------------------+ | # DbName Connect String OK| |-- ------------------------------ ---------------------------------------- --| | 1 /users/progress/dbs/pro7test__ -N tcp -H 194.152.95.26 -S pro7test_____ OK| | 2 ______________________________ ________________________________________ __| | | | | | | | | | | | | | | | | +-----------------------------------------------------------------------------+ Creating .pf file to use Creating .dat file with table information Procedure Complete. Press space bar to continue.
Referenced by...