This structure returns information after a call to sqlengne - Get Next Node Directory Entry.
Table 49. Fields in the SQLENINFO Structure
| Field Name | Data Type | Description | ||
|---|---|---|---|---|
| NODENAME | CHAR(8) | Used for the NetBIOS protocol; the nname of the node where the database is located (valid in system directory only). | ||
| LOCAL_LU | CHAR(8) | Used for the APPN protocol; local logical unit. | ||
| PARTNER_LU | CHAR(8) | Used for the APPN protocol; partner logical unit. | ||
| MODE | CHAR(8) | Used for the APPN protocol; transmission service mode. | ||
| COMMENT | CHAR(30) | The comment associated with the node. | ||
| COM_CODEPAGE | SMALLINT | The code page of the comment. This field is no longer used by the database manager. | ||
| ADAPTER | SMALLINT | Used for the NetBIOS protocol; the local network adapter. | ||
| NETWORKID | CHAR(8) | Used for the APPN protocol; network ID. | ||
| PROTOCOL | CHAR(1) | Communications protocol. | ||
| SYM_DEST_NAME | CHAR(8) | Used for the APPC protocol; the symbolic destination name. | ||
| SECURITY_TYPE | SMALLINT | Used for the APPC protocol; the security type. See below for values. | ||
| HOSTNAME | CHAR(255) | Used for the TCP/IP protocol; the name of the TCP/IP host on which the DB2 server instance resides. | ||
| SERVICE_NAME | CHAR(14) | Used for the TCP/IP protocol; the TCP/IP service name or associated port number of the DB2 server instance. | ||
| FILESERVER | CHAR(48) | Used for the IPX/SPX protocol; the name of the NetWare file server where the DB2 server instance is registered. | ||
| OBJECTNAME | CHAR(48) | The database manager server instance is represented as the object, objectname, on the NetWare file server. The server's IPX/SPX internetwork address is stored and retrieved from this object. | ||
| INSTANCE_NAME | CHAR(8) | Used for the local and NPIPE protocols; the name of the server instance. | ||
| COMPUTERNAME | CHAR(15) | Used by the NPIPE protocol; the server node's computer name. | ||
| SYSTEM_NAME | CHAR(21) | The DB2 system name of the remote server. | ||
| REMOTE_INSTNAME | CHAR(8) | The name of the DB2 server instance. | ||
| CATALOG_NODE_TYPE | CHAR | Catalog node type. | ||
| OS_TYPE | UNSIGNED SHORT | Identifies the operating system of the server. | ||
| ||||
Valid values for SECURITY_TYPE (defined in sqlenv) are:
Language Syntax
C Structure
/* File: sqlenv.h */
/* Structure: SQLENINFO */
/* ... */
SQL_STRUCTURE sqleninfo
{
_SQLOLDCHAR nodename[SQL_NNAME_SZ];
_SQLOLDCHAR local_lu[SQL_LOCLU_SZ];
_SQLOLDCHAR partner_lu[SQL_RMTLU_SZ];
_SQLOLDCHAR mode[SQL_MODE_SZ];
_SQLOLDCHAR comment[SQL_CMT_SZ];
unsigned short com_codepage;
unsigned short adapter;
_SQLOLDCHAR networkid[SQL_NETID_SZ];
_SQLOLDCHAR protocol;
_SQLOLDCHAR sym_dest_name[SQL_SYM_DEST_NAME_SZ];
unsigned short security_type;
_SQLOLDCHAR hostname[SQL_HOSTNAME_SZ];
_SQLOLDCHAR service_name[SQL_SERVICE_NAME_SZ];
char fileserver[SQL_FILESERVER_SZ];
char objectname[SQL_OBJECTNAME_SZ];
char instance_name[SQL_INSTNAME_SZ];
char computername[SQL_COMPUTERNAME_SZ];
char system_name[SQL_SYSTEM_NAME_SZ];
char remote_instname[SQL_REMOTE_INSTNAME_SZ];
_SQLOLDCHAR catalog_node_type;
unsigned short os_type;
};
/* ... */
|
COBOL Structure
* File: sqlenv.cbl
01 SQLENINFO.
05 SQL-NODE-NAME PIC X(8).
05 SQL-LOCAL-LU PIC X(8).
05 SQL-PARTNER-LU PIC X(8).
05 SQL-MODE PIC X(8).
05 SQL-COMMENT PIC X(30).
05 SQL-COM-CODEPAGE PIC 9(4) COMP-5.
05 SQL-ADAPTER PIC 9(4) COMP-5.
05 SQL-NETWORKID PIC X(8).
05 SQL-PROTOCOL PIC X.
05 SQL-SYM-DEST-NAME PIC X(8).
05 FILLER PIC X(1).
05 SQL-SECURITY-TYPE PIC 9(4) COMP-5.
05 SQL-HOSTNAME PIC X(255).
05 SQL-SERVICE-NAME PIC X(14).
05 SQL-FILESERVER PIC X(48).
05 SQL-OBJECTNAME PIC X(48).
05 SQL-INSTANCE-NAME PIC X(8).
05 SQL-COMPUTERNAME PIC X(15).
05 SQL-SYSTEM-NAME PIC X(21).
05 SQL-REMOTE-INSTNAME PIC X(8).
05 SQL-CATALOG-NODE-TYPE PIC X.
05 SQL-OS-TYPE PIC 9(4) COMP-5.
*
|