Schema Reporting Tools for Progress 4GL

The Jargon Software RDU (Remote Development Utility) gives you an easy way to view schema information for Progress databases in various inquiry and report formats. This is especially useful when working with remote Windows NT hosts (over the Internet, for example), where you do not have direct access to a Windows session and typically have no telnet capability.

Create Online HTML Docs For Each Table In A Database

1. Create a subdirectory under the web server root directory, such as "doc\schema\". For example, on Windows NT, this would usually be "C:\inetpub\wwwroot\doc\schema".
2. Within the schema directory, create a subdirectory for each database (for the "sports" DB, it would be ...doc\schema\sports).
3. From the third tab in RDU, enter the following in the editor textarea and then click "execute stmts":
run util/dictdoc.p ("sports", "C:/inetpub/wwwroot/doc/schema/sports").

4. Repeat for each database. Each database directory will contain a table of contents page (index.html) that you can bookmark, which in turn points to an html page for each table (order.html, item.html, etc) these can be viewed any time in a browser, whether or not you are running Jargon Writer. The information is similar to what is shown in the Jargon schema browser program that can be run from RDU (tools menu), but in a different format.

Realtime View Of Schema Definitions For Any Connected Database/Table

1. From RDU, select menubar choice "Tools-->DB Schema Inquiry".
2. In the schema inquiry frame, select a database name.
3. When the table names have loaded, select a table. The table's fields and indexes will be displayed in the two tabs in the tabpanel.

List All Tables In A Database In A Report Format (View/Print In Browser)

1. From the third tab in RDU, click "view schema" to populate the list of database names. Or you can leave it blank and do step 2 and it will use the first connected database name.
2. Enter file specs to be printed. You can do wildcards and special options as follows:

   %Seq   - shows all sequences in the DB
   %List  - shows a list of all table names at the start of the report
   *      - shows detail schema information for all tables except "_" tables
   cust*  - shows detail schema for all tables beginning with "cust"
   _*     - shows detail schema for all tables beginning with "_" (override)

3. Click "View Schema" to create the report, which will be displayed in your default browser (and you can print it from there if you wish).