Administrative API Reference

sqleuncn - Uncatalog Node

Deletes an entry from the node directory.

Authorization

One of the following:

Required Connection

None

Version

sqlenv.h

C API Syntax 



/* File: sqlenv.h */
/* API: Uncatalog Node */
/* ... */
SQL_API_RC SQL_API_FN
  sqleuncn (
    _SQLOLDCHAR * pNodeName,
    struct sqlca * pSqlca);
/* ... */

Generic API Syntax 



/* File: sqlenv.h */
/* API: Uncatalog Node */
/* ... */
SQL_API_RC SQL_API_FN
  sqlguncn (
    unsigned short NodeNameLen,
    struct sqlca * pSqlca,
    _SQLOLDCHAR * pNodeName);
/* ... */

API Parameters

NodeNameLen
Input. A 2-byte unsigned integer representing the length in bytes of the node name.

pSqlca
Output. A pointer to the sqlca structure. For more information about this structure, see SQLCA.

pNodeName
Input. A string containing the name of the node to be uncataloged.

REXX API Syntax 



UNCATALOG NODE nodename

REXX API Parameters

nodename
Name of the node to be uncataloged.

Sample Programs

C
\sqllib\samples\c\nodecat.c

COBOL
\sqllib\samples\cobol\nodecat.cbl

REXX
\sqllib\samples\rexx\nodecat.cmd

Usage Notes

To recatalog the node, use sqlectnd - Catalog Node.

To list the nodes that are cataloged, use sqlenops - Open Node Directory Scan, sqlengne - Get Next Node Directory Entry, and sqlencls - Close Node Directory Scan.

If directory caching is enabled (see the configuration parameter dir_cache in sqlfxsys - Get Database Manager Configuration), database, node, and DCS directory files are cached in memory. An application's directory cache is created during its first directory lookup. Since the cache is only refreshed when the application modifies any of the directory files, directory changes made by other applications may not be effective until the application has restarted. To refresh DB2's shared cache (server only), stop (db2stop) and then restart (db2start) the database manager. To refresh the directory cache for another application, stop and then restart that application.

See Also

sqlectnd - Catalog Node

sqlencls - Close Node Directory Scan

sqlengne - Get Next Node Directory Entry

sqlenops - Open Node Directory Scan.

[ Top of Page | Previous Page | Next Page ]