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.
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.
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.
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.
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:
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 |