QMF users periodically need to list objects they have saved in the database or to view comments that show them what purpose a table serves or what type of data a column in the table contains. The QMF LIST and DESCRIBE commands perform these functions.
When a user issues a LIST or DESCRIBE command for a table, QMF uses a view defined on a set of DB2 catalog tables to obtain information about the table. The name of this view is stored in the global variables DSQEC__TABS__LDB2, DSQEC__TABS__RDB2, or DSQEC_TABS_SQL. When users issue these commands for a column within a table, QMF uses the global variables DSQEC__COLS__LDB2, DSQEC__COLS__RDB2, or DSQEC_COLS_SQL to obtain the name of the view.
QMF provides a set of default views, loaded during installation, that return only the tables and column information the user is authorized to see. Because processing for authorization takes extra time and resources, QMF also allows you to customize the table lists and column information by creating your own views.
[ Previous Page | Next Page | Contents | Index ]