Tabelas SYSIBM

Menu principal [Fechar]

Introdução

Divisões

Identification Division

Environment Division

Data Division

Procedure Division

Comandos CICS

VSAM - File Status

Quadros importantes

SQL - Structured Query Language

Outros programas

Rotinas prontas

Palavras reservadas

Introdução ao Oracle

Sites de busca

Sites interessantes

Meu e-mail

Nome da coluna Tipo de dados Descrição Uso

CREATOR CHAR(8) NOT NULL Authorization ID of the owner of the dependent table of the referential constraint. G

TBNAME VARCHAR(18) NOT NULL Name of the dependent table of the referential constraint. G

RELNAME CHAR(8) NOT NULL Constraint name G

REFTBNAME VARCHAR(18) NOT NULL Name of the parent table of the referential constraint. G

REFTBCREATOR SMALLINT NOT NULL Authorization ID of the owner of the parent table. G

COLCOUNT CHAR(8) NOT NULL Number of columns in the foreign key. G

DELETERULE CHAR(1) NOT NULL Type of delete rule for the referential constraint.

C      CASCADE
N      SET NULL
R      RESTRICT
A      NO ACTION G

IBMREQD CHAR(1) NOT NULL Whether the row came from the basic machine-readable material (MRM) tape:

N      No
Y      Yes S

RELOBID1 SMALLINT NOT NULL
WITH DEFAULT Internal identifier of the constraint with respect to the database that contains the parent table. S

RELOBID2 SMALLINT NOT NULL
WITH DEFAULT Internal identifier of the constraint with respect to the database that contains the dependent table. S

TIMESTAMP TIMESTAMP NOT NULL
WITH DEFAULT The date and time the constraint was defined. If the constraint is between catalog tables prior to DB2 Version 2 Release 3, the value is '1985-04-01-00.00.00.000000.' :epsc.. G

IXOWNER CHAR(8) NOT NULL
WITH DEFAULT Owner of unique non-primary index used for the parent key. '99999999' if the enforcing index has been dropped. Blank if the enforcing index is a primary index. G

IXNAME VARCHAR(18) NOT NULL
WITH DEFAULT Name of unique non-primary index used for a parent key. '99999999' if the enforcing index has been dropped. Blank if the enforcing index is a primary index. G

Nome da coluna	Tipo de dados	Descrição	Uso
CREATOR	CHAR(8) NOT NULL	Authorization ID of the owner of the dependent table of the referential constraint.	G
TBNAME	VARCHAR(18) NOT NULL	Name of the dependent table of the referential constraint.	G
RELNAME	CHAR(8) NOT NULL	Constraint name	G
REFTBNAME	VARCHAR(18) NOT NULL	Name of the parent table of the referential constraint.	G
REFTBCREATOR	SMALLINT NOT NULL	Authorization ID of the owner of the parent table.	G
COLCOUNT	CHAR(8) NOT NULL	Number of columns in the foreign key.	G
DELETERULE	CHAR(1) NOT NULL	Type of delete rule for the referential constraint. C CASCADE N SET NULL R RESTRICT A NO ACTION	G
IBMREQD	CHAR(1) NOT NULL	Whether the row came from the basic machine-readable material (MRM) tape: N No Y Yes	S
RELOBID1	SMALLINT NOT NULL WITH DEFAULT	Internal identifier of the constraint with respect to the database that contains the parent table.	S
RELOBID2	SMALLINT NOT NULL WITH DEFAULT	Internal identifier of the constraint with respect to the database that contains the dependent table.	S
TIMESTAMP	TIMESTAMP NOT NULL WITH DEFAULT	The date and time the constraint was defined. If the constraint is between catalog tables prior to DB2 Version 2 Release 3, the value is '1985-04-01-00.00.00.000000.' :epsc..	G
IXOWNER	CHAR(8) NOT NULL WITH DEFAULT	Owner of unique non-primary index used for the parent key. '99999999' if the enforcing index has been dropped. Blank if the enforcing index is a primary index.	G
IXNAME	VARCHAR(18) NOT NULL WITH DEFAULT	Name of unique non-primary index used for a parent key. '99999999' if the enforcing index has been dropped. Blank if the enforcing index is a primary index.	G