Exit parameter list for connection and sign-on routines

The parameter list of connection and sign-on routines contains pointers to other information, such as the authorization ID list.

Begin program-specific programming interface information.The following diagram shows how the parameter list points to other information.
Figure 1. How a connection or sign-on parameter list points to other information
Begin figure description. The connection or sign-on parameter list points to other information. End figure description

Connection routines and sign-on routines use 28 more bytes of the exit parameter list EXPL than other routines. The following table shows the entire list of connection routines and sign-on routines. The exit parameter list is described by macro DSNDEXPL.

Table 1. Exit parameter list for connection routines and sign-on routines
Name Hex offset Data type Description
EXPLWA 0 Address Address of a 8192-byte work area to be used by the routine.
EXPLWL 4 Signed 4-byte integer Length of the work area, in bytes; value is 8192.
EXPLRSV1 8 Signed 2-byte integer Reserved.
EXPLRC1 A Signed 2-byte integer Not used.
EXPLRC2 C Signed 4-byte integer Not used.
EXPLARC 10 Signed 4-byte integer Access return code. Values can be:
0
Access allowed; Db2 continues processing.
12
Access denied; Db2 terminates processing with an error.
EXPLSSNM 14 Character, 8 bytes Db2 subsystem name, left justified; for example, 'DSN '.
EXPLCONN 1C Character, 8 bytes Connection name for requesting location.
EXPLTYPE 24 Character, 8 bytes Connection type for requesting location. For DDF/REST threads, the connection type is 'REST    '.
EXPLSITE 2C Character, 16 bytes For SNA protocols, this is the location name of the requesting location or <luname>. For TCP/IP protocols, this is the dotted decimal IP address of the requester. If the value of EXPLSITE_OFF is not 0, EXPLSITE is not used.
EXPLLUNM 3C Character, 8 bytes For SNA protocols, this is the locally known LU name of the requesting location. For TCP/IP protocols, this is the character string 'TCPIP'.
EXPLNTID 44 Character, 17 bytes For SNA protocols, the fully qualified network name of the requesting location. For TCP/IP protocols, this field is reserved.
EXPLVIDS 55 Character, 1 byte Db2 version identifier
EXPLSITE_OFF 56 Signed 2-byte integer Offset from the beginning of the work area to the extended location name of the Db2 site that originated the work request. Use this value if the location name is greater than 16 bytes. The extended location name has the following format:
  • Signed, 2-byte integer: Length of the extended location name
  • Character, 128 bytes: Extended location name
End program-specific programming interface information.