This view is based on another view, the SYSCAT.TABAUTH catalog view.
该视图基于另一个视图 SYSCAT.TABAUTH编目视图。
The distribution statistics are stored in the system catalog view SYSCAT.COLDIST.
分布统计信息存储在系统编目视图SYSCAT.COLDIST 中。
The importance of the value recorded in the tabauth field in the dependency catalog view
依赖项编目视图中tabauth 字段中记录的值的重要性
As mentioned earlier, no single system catalog view contains all the available authorization data.
如前所述,没有哪个单独的系统编目视图可以包含所有可用的授权数据。
For more information about the definition of each catalog view, refer to the DB2 UDB SQL Reference (see Resources).
要了解关于每个编目视图的定义的更多信息,请参阅DB 2UDBSQLReference(见参考资料)。
The information about occurrences of NULL values is stored in the NUMNULLS column of the system catalog view SYSCAT.COLUMNS.
关于null值出现次数的信息存储在系统编目视图syscat .COLUMNS中的NUMNULLS列中。
To get the name of the index with ID 3, query the SYSCAT.INDEXES catalog view using a SELECT statement, as shown in Listing 12.
要获得ID3索引的名称,请使用SELECT语句查询 SYSCAT.INDEXES目录视图,如清单 12 所示。
A catalog view can be based on one or more catalog tables, and the view column names are often different than their counterparts in the catalog table.
一个编目视图可以基于一个或多个编目表,并且视图中的列名常常与它们在编目表中对应的列不同。
To do this, you first need to determine the tablespace ID and table ID of the table by executing a SELECT statement on the SYSCAT.TABLES catalog view, as shown in Listing 8.
为此,您首先需要在SYSCAT . TABLES目录视图上执行select语句来确定表空间id和表id,如清单8所示。
Using this table function instead of db2pd simplifies evaluation of the results because the index IDs (IIDs) can be converted to index names by joining with the SYSCAT.INDEXES catalog view.
使用表函数取代 db2pd实用程序简化了结果计算,因为可以通过与 SYSCAT.INDEXES 目录视图结合将索引IDs (IIDs)转换成索引名。
If you create a database named body_parts with the tables and data shown previously, your Catalog view should resemble this.
如果用前面所示的表和数据创建名为body_parts的数据库,则catalog视图应当类似以下内容。
If you create a database named body_parts with the tables and data shown previously, your Catalog view should resemble this.
如果用前面所示的表和数据创建名为body_parts的数据库,则catalog视图应当类似以下内容。
应用推荐