Progress
Basic Database
Tools


Database>Reports

Choose Database Reports to generate reports about the schema in the database. Table 8–4 describes the submenu that appears when you choose this option.

Table 8–4: Reports Menu
Report
Detailed Table
Displays details about one or all tables in this database, including field, sequence, and index information.
Quick Table
Displays a summary of all the tables in this database.
Quick Field
Displays field information for one or all tables defined in the working database.
Quick Index
Displays index information for one or all tables defined in the working database.
PRO/SQL View
Displays PRO/SQL view information for all the views defined in the working database.
Sequence
Displays sequences information for all the sequences defined in the working database.
Trigger
Displays trigger information for all the triggers defined in the working database.
User
Displays the current database users, user IDs, and whether each user has a password. You specify this information with the Data Dictionary.
Table Relations
Displays the relations for one or all tables defined in the working database.
Storage Areas
Displays the storage area information for all storage areas defined in the working database.

Reports Detailed Table

Choose Reports Detailed Table to generate information about the structure of the selected table or of all the tables in the working database. This option creates a report that displays all information about the tables, including information about fields and indexes defined for the tables.

When you choose this option and you select a table, Progress displays the Report Options dialog box as shown in Figure 8–6.

Figure 8–6: Report Options Dialog Box

This dialog box has the following user-interface elements:

Send Output to

Lets you send output to the screen, the default printer for your computer system, or a file.

If you choose to send output to a file, specify the filename and whether to append the report information to an existing file. Choose the Files button to display a list of existing files.

Page Length

Specifies the number of lines per page. The default for the printer is 60 lines; for the terminal and a file it is 0 (continuous).

Order Fields

Specifies whether to order the fields for the report by order number or alphabetically.

Figure 8–7 shows a portion of a detailed table report for all the tables in the sports database.

Figure 8–7: Detailed Table Report Dialog Box

Reports Quick Table

Choose Reports Quick Table to display summary information about all the tables in the working database. For each table Progress lists the table name, storage area number, dump name, table flags, field count, index count, and table label. Figure 8–8 shows an example of a quick table report for the sports database.

Figure 8–8: Quick Table Report Dialog Box

Reports Quick Field

Choose Reports Quick Field to display information for the structure of fields in one or all tables in the working database. For each field, Progress lists the order number, name, data type, flags, and format.

The Data Type column lists the first four characters of the field’s data type. If the type is decimal, the report includes the number of stored decimals digits (for example, deci–2). If the field is an array, the report includes the extent (for example, char[10]). The report shows a decimal array field as deci–2[5]. The Flags column indicates whether the field is case sensitive, mandatory, an index component, or a view component. Figure 8–9 shows an example of a quick field report for the customer table in the sports database.

Figure 8–9: Quick Field Report Dialog Box

The Quick Field Report window has the following user-interface elements:

Switch Tables

Returns you to the list of tables for the working database.

Change Field Order

Changes the sort order of the fields to either alphabetical by name or numeric by order.

Print

Lets you print the report or write it to a file.

Reports Quick Index

Choose Reports Quick Index to display information about the indexes defined in one or all tables in the working database. For each table, the report lists the index flags, name of the index, storage area number, and fields that define the index. The Flags column indicates whether the indexes are primary, unique, word, abbreviated, or inactive. A plus (+) or minus (-) sign next to the field name indicates if the index is ascending or descending. Figure 8–10 shows an example of a quick index report for the customer table of the sports database.

Figure 8–10: Quick Index Report Dialog Box

The Quick Index Report window has the following user-interface elements:

Switch Tables

Returns you to the list of tables for the working database.

Print

Lets you print the report or write it to a file.

Reports PRO/SQL View

Choose Reports PRO/SQL View to display information about all SQL views defined for the working database. For each view, it shows the name of the view, whether each view can be updated, and if a GROUP BY phrase or a check option was used. It also shows the base table name, WHERE clause criteria, and view definition. Figure 8–11 shows an example of an SQL View Report for the customer table of the sports database.

Figure 8–11: PRO/SQL View Report Dialog Box

Choose the Print button to print the report or to write it to a file.

Reports Sequence

Choose Reports Sequence to display information about all sequences defined in the current database. For each sequence, it shows the name of the sequence, its initial value, increment value, minimum or maximum value, and whether the sequence cycles or stops at the maximum value. Figure 8–12 shows an example of a sequence report for the sports database.

Figure 8–12: Sequence Report Dialog Box

Choose the Print button to print the report or to write it to a file.

Reports Trigger

Choose Reports Trigger to list all tables and fields in the report that have triggers defined for them. It lists the table or field name for which the trigger is defined, type of event that causes the trigger to fire, whether the Dictionary checks the cyclical redundancy check (CRC) code for the trigger procedure, trigger flags, and the name of the procedure. The Flags column indicates if the trigger is overridable, has a mismatched CRC code, or has no r-code available. Figure 8–13 shows an example of a trigger report for the sports database.

Figure 8–13: Trigger Report Dialog Box

Choose the Print button to print the report or to write it to a file.

Reports User

Choose Reports User to display the list of users who have permission to use the working database. This information is stored in the user list in the _User file. Figure 8–14 shows an example of a user report.

Figure 8–14: User Report Dialog Box

Choose the Print button to print the report or to write it to a file.

Reports Table Relations

Choose Reports Table Relations to list the implicit join relations for one or all tables in the working database. Figure 8–15 shows an example of a Table Relations Report for the customer table of the sports database.

Figure 8–15: Table Relations Report Dialog Box

The Table Relations Report window has the following user-interface elements:

Switch Tables

Returns you to the list of tables for the working database.

Print

Lets you print the report or write it to a file.

Reports Storage Areas

Choose Reports Storage Areas to list the storage areas in the working database. The report lists storage area number, type, block size, total extents, and area name. Figure 8–16 shows an example of a Storage Areas Report for all tables of the sports database.

Figure 8–16: Quick Storage Areas Report Dialog Box

The Quick Storage Area Report window has the following user-interface element:

Print

Lets you print the report or write it to a file.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095