---

---

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

Nome da coluna	Tipo de dados	Descrição	Uso
NAME	VARCHAR(18) NOT NULL	Name of the view.	G
CREATOR	CHAR(8) NOT NULL	Authorization ID of the owner of the view.	G
SEQNO	SMALLINT NOT NULL	Sequence number of this row; the first portion of the view is on row one  and successive rows have increasing values of SEQNO.	G
CHECK	CHAR(1) NOT NULL	Whether the WITH CHECK OPTION clause was specified in the CREATE  VIEW statement:  N      No  C      Yes with the cascaded semantic  Y      Yes with the local semantic  The value is N if the view has no WHERE clause.	G
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
TEXT	VARCHAR(254) NOT NULL	Text or portion of the text of the CREATE VIEW statement.	G
PATHSCHEMAS	VARCHAR(254) NOT NULL  WITH DEFAULT	SQL path at the time the view was defined. The path is used to resolve  unqualified data type and function names used in the view definition.	G
RELCREATED	CHAR(1) NOT NULL  WITH DEFAULT	Release of DB2 that was used to create the object:  blank          Created prior to Version 7.  K                 Created on Version 7	G
TYPE	CHAR(1) NOT NULL   WITH DEFAULT 'V'	Type of table:  F        SQL function  V        View	G