DB2 10.5 for Linux, UNIX, and Windows

sqle_node_struct data structure

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

Table 1. Fields in the SQLE-NODE-STRUCT Structure
Field Name Data Type Description
STRUCT_ID SMALLINT Structure identifier.
CODEPAGE SMALLINT Code page for comment.
COMMENT CHAR(30) Optional description of the node.
NODENAME CHAR(8) Local name for the node where the database is located.
PROTOCOL CHAR(1) Communications protocol type.
Note: The character fields passed in this structure must be null terminated or blank filled up to the length of the field.
Valid values for PROTOCOL (defined in sqlenv) are:
  • SQL_PROTOCOL_APPC
  • SQL_PROTOCOL_APPN
  • SQL_PROTOCOL_CPIC
  • SQL_PROTOCOL_LOCAL
  • SQL_PROTOCOL_NETB
  • SQL_PROTOCOL_NPIPE
  • SQL_PROTOCOL_SOCKS
  • SQL_PROTOCOL_TCPIP

API and data structure syntax

SQL_STRUCTURE sqle_node_struct
{
        unsigned short struct_id;
        unsigned short codepage;
        _SQLOLDCHAR comment[SQL_CMT_SZ + 1];
        _SQLOLDCHAR nodename[SQL_NNAME_SZ + 1];
        unsigned char  protocol;
};

COBOL Structure

* File: sqlenv.cbl
01 SQL-NODE-STRUCT.
    05 STRUCT-ID              PIC 9(4) COMP-5.
    05 CODEPAGE               PIC 9(4) COMP-5.
    05 COMMENT                PIC X(30).
    05 FILLER                 PIC X.
    05 NODENAME               PIC X(8).
    05 FILLER                 PIC X.
    05 PROTOCOL               PIC X.
    05 FILLER                 PIC X(1).
*