大家在查：烟吸烟普雷斯特 42nd 法兹· 不为瓦全 Sino - 古时起誓胃动素 dignifies Mameluke

SYSCAT

网络系统编目表

SYSCAT

网络释义

SYSCAT

系统编目表

有关权限的信息存储在系统编目表（SYSCAT）中，我们可以通过下面的SQL语句看到所有与权限相关的系统编目表。isis:db2ld…

例句：

SYSCAT. COLDIST contains entries for a certain table only if distribution statistics have been collected for at least one of its columns .

仅在收集了一个表中至少一个列的分布统计信息时，SYSCAT.COLDIST 才会包含关于该表的条目。

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 所示。

The recommended user access to the catalog is through a set of views with the schema of SYSCAT.

建议用户通过一组 SYSCAT 模式的视图来访问编目。

SYSCAT: A set of read-only views for the system catalog tables .

SYSCAT ：一组只读的系统编目表视图。

The information about occurrences of NULL values is stored in the NUMNULLS column of the system catalog view SYSCAT. COLUMNS .

关于 NULL 值出现次数的信息存储在系统编目视图 SYSCAT.COLUMNS 中的 NUMNULLS 列中。

Assuming you know the federated procedure name and schema , SYSCAT. ROUTINEPARMS is the catalog you begin with.

假设您知道联邦过程的名称和模式，SYSCAT.ROUTINEPARMS 是首先查询的编目。

One set of read-only views is created under the SYSCAT schema , and a smaller set of updatable views is created under the SYSSTAT schema .

其中一组只读视图在 SYSCAT 模式下创建，另一组更小的可更新视图则是在 SYSSTAT 模式下创建的。

Notice how Microsoft Access discovers all the tables in the database , including those in the SYSCAT schema .

注意 MicrosoftAccess 如何发现数据库中的所有表，包括 SYSCAT 模式中的表。

You can list buffer pool information by querying the SYSCAT. BUFFERPOOLS system view , as shown in Listing 7.

通过查询 SYSCAT.BUFFERPOOLS 系统视图可以列出缓冲池信息，如清单 7 所示。

The system catalog table SYSCAT. DATAPARTITIONS is then updated to reflect the change .

然后，系统目录表 SYSCAT.DATAPARTITIONS 被更新来反映这个更改。

The distribution statistics are stored in the system catalog view SYSCAT. COLDIST.

分布统计信息存储在系统编目视图 SYSCAT.COLDIST 中。

By querying the STATUS column of the SYSCAT. DATAPARTITIONS catalog view for the partition in question.

通过针对问题分区来查询 SYSCAT.DATAPARTITIONS 目录视图的列 STATUS 。

The composition of the DDL objects is entirely based on the documented SYSCAT catalog views , with one exception .

DDL 对象的组成完全基于文档记录的 SYSCAT 编目视图，只有一个例外。

The SYSCAT schema contains useful read-only views of the catalog tables .

SYSCAT 模式包含编目表的有用只读视图。

This can be verified by executing a query against the DB2 catalog views SYSCAT. TABLES and SYSCAT. TABLESPACES.

可以通过对 DB2 编目视图 SYSCAT.TABLES 和 SYSCAT.TABLESPACES 执行查询来确认这一点。

Runstats updates column CARD in syscat. tables to zero rows on multi partitioned instance after load .

加载表之后，Runstats 将多分区实例上 syscat.tables 中的列 CARD 更新为零行。

The SYSCAT. TABDEP system catalog view contains a row for every dependency that a materialized query table has on some other object .

在 SYSCAT.TABDEP 系统编目视图中，对于一个物化查询表在其他对象上的每个依赖关系，都有相应的一行。

An example of a more complex view that is based on more than one table is SYSCAT. STATEMENTS.

另一个例子是一个更复杂的基于多个表的视图，即 SYSCAT.STATEMENTS 。

The following code establishes a connection to the SAMPLE database and returns a list of all the catalog views in the SYSCAT schema

下面的代码将建立到 SAMPLE 数据库的连接，并返回 SYSCAT 模式中所有编目视图的一个列表

SYSCAT

SYSCAT

系统编目表

热词推荐

大家在看