SQL - SYSIBM.SYSSYNONYMS - www.cadcobol.com.br


Volta ao Menu das SYSIBM

Volta ao Menu Principal


Desenvolvido por DORNELLES, Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

SYSIBM.SYSSYNONYMS

Contains one row for each synonym of a table or view.

Nome da coluna Tipo de dados Descrição Uso
 NAME  VARCHAR(8) NOT NULL  Synonym for the table or view. G
 CREATOR  CHAR(8) NOT NULL  Authorization ID of the owner of the synonym. G
 TBNAME  VARCHAR(18) NOT NULL  Name of the table or view. G
 IBMREQD  CHAR(1) NOT NULL  Whether the row came from the Whether the row came from thebasic  machine-readable material (MRM) tape:

 N    No
 Y    Yes
G
 CREATEDBY  CHAR(8) NOT NULL  Primary authorization ID of the user who created the synonym. G
 CREATEDTS  TIMESTAMP NOT NULL
 WITH DEFAULT
 Time when the CREATE statement was executed for the synonym. The  '0001-01.01.00.00.00.000000' for synonyms created in a DB2 release prior  to Version 5. G


© Copyright IBM Corp.