Browse Prior Art Database

Wild Card Support for Uncatalog Database and Uncatalog Node OS/2 DBM APIs

IP.com Disclosure Number: IPCOM000103737D
Original Publication Date: 1993-Jan-01
Included in the Prior Art Database: 2005-Mar-18
Document File: 4 page(s) / 144K

Publishing Venue

IBM

Related People

Jacobs, DC: AUTHOR

Abstract

A method is described which will provide a mechanism with which the user of the OS/2* Database Management System can uncatalog all or groups of databases or nodes by allowing wild-card characters in the UNCATALOG DATABASE and in the UNCATALOG NODE environment APIs. OS/2 Database Manager provides function to catalog and uncatalog databases, and nodes. Databases:

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 40% of the total text.

Wild Card Support for Uncatalog Database and Uncatalog Node OS/2 DBM APIs

       A method is described which will provide a mechanism with
which  the user of the OS/2* Database Management System can uncatalog
all or groups of databases or nodes by allowing wild-card characters
in the UNCATALOG DATABASE and in the UNCATALOG NODE environment APIs.
OS/2 Database Manager provides function to catalog and uncatalog
databases, and nodes.
Databases:

      The CATALOG DATABASE environment API stores database directory
entries for databases that applications may want to reference.
Databases that were created on remote nodes (REMOTE) or on other
drives on the same node, such as diskette drives (INDIRECT), need
this function to be executed before access can be made to them.

      The UNCATALOG DATABASE environment is used to delete a database
entry from the database directory file.  Entries that are marked as
indirect or remote can be uncataloged with this command.  The
uncatalog database prototype for the C programming language is as
follows:
  SQL_API_RC  SQL_API_FN         /* UNCATALOG DATABASE    */
  sqleuncd_api (unsigned char *,     /* database */
                struct sqlca *);     /* SQLCA */
          parameters:
            database       Name or alias of the database entry to
drop.  The database must be cataloged in the System Database
Directory.
            sqlca          An area for return codes.
Nodes:

      The CATALOG NODE environment APIis used to create a nodename
entry in the node directory file.  The nodename entries contain
information required to establish the connection between the
application and a remote database.

      The UNCATALOG NODE environment API is used to delete a nodename
from the node directory file.  The uncatalog node API prototype for
the C programming language is as follows:
  SQL_API_RC  SQL_API_FN             /* UNCATALOG NODE */
  sqleuncn_api (unsigned char *,     /* nodename */
                struct sqlca *);     /* SQLCA */
          parameters:
              nodename       Name of the node to be uncataloged.
              sqlca          An area for return codes.
Problem:

      The UNCATALOG DATABASE and the UNCATALOG NODE APIs only provide
for the deletion of one cataloged entry at a time.  It may be a
requirement that several databases or several nodes, that are
cataloged on a system, be removed from the database or node
directory.  In these situations, the following algorithm would
typically be used:
     step 1> An open directory scan must be executed (sqledops or
sqlenops).
     step 2> A get next entry must be performed for each database or
node (sqledgne or sqlengne).
     step 3> If the database name or node name matches, an UNCATALOG
DATABASE or UNCATALOG NODE API call must be i...