DB2 Version 9.7 for Linux, UNIX, and Windows

sqle_node_tcpip data structure

This structure is used to catalog TCP/IP nodes for the sqlectnd API.

Note: To catalog a TCP/IP, TCP/IPv4 or TCP/IPv6 node, set the PROTOCOL type in the node directory structure to SQL_PROTOCOL_TCPIP, SQL_PROTOCOL_TCPIP4 or SQL_PROTOCOL_TCPIP6 respectively in the SQLE-NODE-STRUCT structure before calling the sqlectnd API. To catalog a TCP/IP or TCP/IPv4 SOCKS node, set the PROTOCOL type in the node directory structure to SQL_PROTOCOL_SOCKS or SQL_PROTOCOL_SOCKS4 respectively in the SQLE-NODE-STRUCT structure before calling the sqlectnd API. SOCKS is not supported on IPv6. For example, SQL_PROTOCOL_SOCKS with an IPv6 address is not supported.

Table 1. Fields in the SQLE-NODE-TCPIP Structure
Field Name	Data Type	Description
HOSTNAME	CHAR(255)	Hostname or IP address on which the DB2® server instance resides. The type of IP address accepted depends on the protocol selected.
SERVICE_NAME	CHAR(14)	TCP/IP service name or associated port number of the DB2 server instance.

Note: The character fields passed in this structure must be null terminated or blank filled up to the length of the field.

API and data structure syntax

SQL_STRUCTURE sqle_node_tcpip
{
        _SQLOLDCHAR hostname[SQL_HOSTNAME_SZ+1];
        _SQLOLDCHAR service_name[SQL_SERVICE_NAME_SZ+1];
};

COBOL Structure

* File: sqlenv.cbl
01 SQL-NODE-TCPIP.
    05 HOSTNAME               PIC X(255).
    05 FILLER                 PIC X.
    05 SERVICE-NAME           PIC X(14).
    05 FILLER                 PIC X.
*