Schema Reporting Tools for Progress 4GL


The Jargon Software RDU program (Remote Development Utility Version 3) 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 servers over the Internet, 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 document root directory, such as "doc\schema\". For example, on a Windows server running IIS, this would usually be "C:\inetpub\wwwroot\doc\schema".

  2. Within the schema directory, create a subdirectory for each database (for the "sports2000" database, it would be C:\inetpub\wwwroot\doc\schema\sports2000).

  3. From the "Databases" window in RDU:
    • Select the database in the combobox. Clicking it in the selection box will fill in a default "Doc Dir" value also.
    • Verify or enter the web server's document root directory in the "Doc. Root" textfield (default is for Windows IIS).
    • Verify or enter the document subdirectory (relative to Doc. Root) in the "Doc. Dir." textfield.
    • Click the "Create DB Docs" button.
    • When completed, the URL of the index page (index.html) will be displayed in the http window of RDU. If you are using the PDA Emulator or PC version of Jargon Reader, you can view the documents in your default browser.

  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 discussed below (dbutil), but in a different format.


List Selected Database Information In A Report Format (View/Print In Browser)

  1. From the same "Databases" window in RDU:
    • Select the database in the combobox.
    • Verify or enter the web server's document root directory in the "Doc. Root" textfield (default is for Windows IIS).
    • Enter the table name(s) or other specs to be printed.
    • Verify or enter the temporary report subdirectory (relative to Doc. Root) in the "Rep. Dir." textfield, such as "temp/" for the directory c:\inetpub\wwwroot\temp. Note that this directory must already exist, it will NOT be created.
    • Click the "Create DB Report" button.
    • When completed, the URL of a temporary HTML page in the report directory will be displayed in the http window of RDU. If you are using the PDA Emulator or PC version of Jargon Reader, you can view it in your default browser.

  2. You can do wildcards and special options as follows:

    %Seq   - shows all sequences in the DB

  3. %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)


Realtime View Of Schema Definitions For Any Connected Database/Table

  1. From the same "Databases" window in RDU, click the "Run DB Utility" button.

  2. This will open and run the "dbutil" or "dbwin" application.

  3. Select a database from the first combobox.

  4. When the table names have loaded, select a table.

  5. Click "View Contents" to see the table's fields in a table format. Scroll to the right to see field attributes.

  6. You can also view record values from the window by using the First/Next/Prev/Last buttons.

  7. Select "Filter" to apply data filters to limit which data records are displayed.

  8. Select a row in the table and click "Detail" to see all field information for the selected field.

  9. Select a row in the table and click "Update" to be able to update the value of that field in that record.

  10. Note that when you exit dbutil, it returns you to the Jargon Reader startup menu, not to RDU.


Return to Help Index