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
- 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".
- Within the schema directory, create a subdirectory for each database (for
the "sports2000" database, it would be C:\inetpub\wwwroot\doc\schema\sports2000).
- 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.
- 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)
-
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.
- 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)
Realtime View Of Schema Definitions For Any Connected
Database/Table
- From the same "Databases" window in RDU, click the "Run DB Utility" button.
- This will open and run the "dbutil" or "dbwin" application.
- Select a database from the first combobox.
- When the table names have loaded, select a table.
- Click "View Contents" to see the table's fields in a table format. Scroll
to the right to see field attributes.
- You can also view record values from the window by using the First/Next/Prev/Last
buttons.
- Select "Filter" to apply data filters to limit which data records are displayed.
- Select a row in the table and click "Detail" to see all field information
for the selected field.
- Select a row in the table and click "Update" to be able to update the value
of that field in that record.
- Note that when you exit dbutil, it returns you to the Jargon Reader startup
menu, not to RDU.
Return to Help Index