SYSIBM.SYSAUXRELS
                        www.cadcobol.com - linguagem de programação COBOL

Volta a página anterior

Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF.

Contains one row for each auxiliary table created for a LOB column. A base table space that is partitioned must have one auxiliary table for each partition of each LOB column.

Nome da coluna Tipo do dado Descrição Uso
 TBOWNER  CHAR(8) NOT NULL  Authorization ID of the owner of the base table.  G
 TBNAME  VARCHAR(18) NOT NULL  Name of the base table.  G
 COLNAME  VARCHAR(18) NOT NULL  Name of the LOB column in the base table.  G
 PARTITION  SMALLINT NOT NULL  Partition number if the base table space is partitioned. Otherwise, the value is 0.  G
 AUXTBOWNER  CHAR(8) NOT NULL  Authorization ID of the owner of the auxiliary table.  G
 AUXTBNAME  VARCHAR(18) NOT NULL  Name of the auxiliary table.  G
 AUXRELOBID  INTEGER NOT NULL  Internal identifier of the relationship between the base table and the auxiliary table.  S
 IBMREQD  CHAR(1) NOT NULL  A value of Y indicates that the row came from the basic machine-readable material  (MRM) tape. For all other values, see Release dependency indicators in topic D.0.  G