IBM Books

API Reference

SQLE-ADDN-OPTIONS

This structure is used to pass information to sqleaddn - Add Node).

Table 20. Fields in the SQLE-NODE-APPN Structure
Field Name Data Type Description
SQLADDID CHAR An "eyecatcher" value which must be set to SQLE_ADDOPTID_V51.
TBLSPACE_TYPE UNSIGNED LONG Specifies the type of temporary table space definitions to be used for the node being added. See below for values.
TBLSPACE_NODE SQL_PDB_NODE_TYPE Specifies the node number from which the temporary table space definitions should be obtained. The node number must exist in the db2nodes.cfg file, and is only used if the tblspace_type field is set to SQLE_TABLESPACES_LIKE_NODE.

Valid values for TBLSPACE_TYPE (defind in sqlenv) are:

SQLE_TABLESPACES_NONE
Do not create any temporary table spaces.
SQLE_TABLESPACES_LIKE_NODE
The containers for the temporary table spaces should be the same as those for the specified node.
SQLE_TABLESPACES_LIKE_CATALOG
The containers for the temporary table spaces should be the same as those for the catalog node of each database.

Language Syntax

C Structure 



/* File: sqlenv.h */
/* Structure: SQLE-ADDN-OPTIONS */
/* ... */
SQL_STRUCTURE sqle_addn_options
{
  char                   sqladdid[8];
  unsigned long          tblspace_type;
  SQL_PDB_NODE_TYPE      tblspace_node;
};
/* ... */

COBOL Structure 



* File: sqlenv.cbl
01 SQLE-ADDN-OPTIONS.
    05 SQLADDID               PIC X(8).
    05 SQL-TBLSPACE-TYPE      PIC 9(9) COMP-5.
    05 SQL-TBLSPACE-NODE      PIC S9(4) COMP-5.
    05 FILLER                 PIC X(2).
*

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]