SQL - SYSIBM.SYSROUTINES_OPTS - 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_OPTS

Contains a row for each generated routine, such as one created by the DB2 Stored Procedure Builder tool, that records the build options for the routine.
Rows in this table can be inersted, 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 options is the current version  G
 BUILDSCHEMA  CHAR(8) NOT NULL  Schema name for BUILDNAME.  G
 BUILDNAME  CHAR(18) NOT NULL  Procedure used to create the routine.  G
 BUILDOWNER  CHAR(8) NOT NULL  Authorization ID used to create the routine.  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
 PRECOMPILE_OPTS  VARCHAR(255) NOT NULL
 WITH DEFAULT		  Precompiler options used to build the routine.  G
 COMPILE_OPTS  VARCHAR(255) NOT NULL
 WITH DEFAULT		  Compiler options used to build the routine.  G
 PRELINK_OPTS  VARCHAR(255) NOT NULL
 WITH DEFAULT		  Prelink-edit options used to build the routine.  G
 LINK_OPTS  VARCHAR(255) NOT NULL
 WITH DEFAULT		  Link-edit options used to build the routine.  G
 BIND_OPTS  VARCHAR(1024) NOT NULL
 WITH DEFAULT		  Bind options used to build the routine.  G
 SOURCEDSN  VARCHAR(255) NOT NULL
 WITH DEFAULT		  Name of the source data set.  G

© Copyright IBM Corp.