SQL - SYSIBM.SYSROUTINES_SRC - 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.SYSROUTINES_SRC

Contains source for generated routines, such as those created by the DB2 Stored Procedure Builder tool. Rows in this table can be inserted, updated, and deleted.

Nome da coluna Tipo do dado Descrição Uso
 SCHEMA  CHAR(8) NOT NULL  Schema of the routine.  G
 ROUTINENAME  CHAR(18) NOT NULL  Name of the routine.  G
 BUILDDATE  DATE NOT NULL
 WITH DEFAULT		  Date the routine was built  G
 BUILDTIME  TIME NOT NULL
  WITH DEFAULT		  Time the routine was built  G
 BUILDSTATUS  CHAR(1) NOT NULL
  WITH DEFAULT 'C' 		 Whether this version of the routine's source is the current version  G
 SEQNO  INTEGER NOT NULL  Number of the source statement piece in CREATESTMT.  G
 IBMREQD  CHAR(1) NOT NULL WITH DEFAULT 'N'  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
 CREATESTMT  VARCHAR(3800) NOT NULL  Routine source statement.  G

© Copyright IBM Corp.