You use this program to view data tables/files, including table, column and index information for each table/file.
| Field | Description |
|---|---|
| View | |
| Table Properties | Loads the Data Dictionary Table Properties program to view detailed information for the selected table. |
| View Data | Loads the Data Dictionary Data Viewer program to view the physical data within the selected table. |
| Classic View Data | Loads the Data Dictionary Classic Data Viewer program to view the data in all
columns of the selected table. The Classic Data Viewer cannot be used to view SQL only tables (i.e. tables that have an ISAM file name of {CompanyDb}. You need to use the View Data option to view the data within these files. |
| Status bar | Displays additional information such as the number of tables/files currently being displayed. |
The data dictionary consists of two sets of tables, the older ISAM only tables (DDSFIL & DDSFLD) and the new ISAM and SQL tables (DDSTAB & DDSCOL).
Only MAX tables are imported into new tables as these tables are intended to replace the older ones. MAX is the suffix of the internal copybook of the SQL Only tables, in the same way as MAC is used as the suffix for C-ISAM and SQL files/tables. MAX tables can only be viewed using the View Data option.
| Column | Description |
|---|---|
| Table name | This indicates the table name. |
| File code | This indicates the physical disk file name of the table. |
| Description | This indicates the description of the table. |
| Rlen | This indicates the record length, which is the number of characters for the lines within the table. |
| Klen | This indicates the key length. This is the number of characters occupied by the key column within the table. |
| ISAM file name | This indicates the C-ISAM file
name. {CompanyDb} indicates that the table is only available in SQL, and has never been available in C-ISAM. |