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

Each row in the table is used to carry out one of the following operations:
Outbound ID translation
Inbound ID translation and "come from" checking
Rows in this table can be inserted, updated, and deleted.

Nome da coluna Tipo do dado Descrição Uso
 TYPE  CHAR(1) NOT NULL  How the row is to be used:

 O    For outbound translation.
 I    For inbound translation and "come from" checking.
 G
 AUTHID  CHAR(8) NOT NULL
 WITH DEFAULT
 Authorization ID to be translated. Applies to any authorization ID if blank.  G
 LINKNAME  CHAR(8) NOT NULL  Identifies the VTAM or TCP/IP network locations associated with this row. A blank  value in this column indicates this name translation rule applies to any TCP/IP or  SNA partner.

 If a nonblank LINKNAME is specified, one or both of the following statements must  be true:

 °  A row exists in SYSIBM.LUNAMES whose LUNAME matches the value specified in      the SYSIBM.USERNAMES LINKNAME column. This row specifies the VTAM site      associated with this name translation rule.

 °  A row exists in SYSIBM.USERNAMES whose LINKNAME matches the value specified      in the SYSIBM.USERNAMES LINKNAME column. This row specifies the TCP/IP      host associated with this name translation rule.

     Inbound name translation and "come from" checking are not performed for      TCP/IP clients.
 G
 NEWAUTHID  CHAR(8) NOT NULL
 WITH DEFAULT
 Translated value of AUTHID. Blank specifies no translation.  G
 PASSWORD  CHAR(8) NOT NULL
 WITH DEFAULT
 Password to accompany an outbound request, if passwords are not encrypted. If  passwords are encrypted, or the row is for inbound requests, the column is not  used.  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.