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

Associates a mode name with any conversation created to support an outgoing SQL request. Each row represents one or more combinations of LUNAME, authorization ID, and application plan name. Rows in this table can be inserted, updated, and deleted.


Nome da coluna Tipo do dado Descrição Uso
AUTHID CHAR(8) NOT NULL
WITH DEFAULT		 Authorization ID of the SQL request. Blank (the default) indicates that the MODENAME specified for the row is to apply to all authorization IDs. G
PLANNAME CHAR(8) NOT NULL
WITH DEFAULT		 Plan name associated with the SQL request. Blank (the default) indicates that the MODENAME specified for the row is to apply to all plan names. G
LUNAME CHAR(8) NOT NULL LU name associated with the SQL request. G
MODENAME CHAR(8) NOT NULL Name of the logon mode in the VTAM logon mode table to be used in support of the outgoing SQL request. If blank, IBMDB2LM is used for DB2 private protocol connections and IBMRDB is used for DRDA connections. 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

© Copyright IBM Corp.