IBM Books

API Reference


Chapter 3. Data Structures

This section describes the data structures used to access the database manager. The following data structures are provided:

RFWD-INPUT
Transfers rollforward information between an application and the database manager
RFWD-OUTPUT
Transfers rollforward information between an application and the database manager
SQL-AUTHORIZATIONS
Returns authorizations information
SQL-DIR-ENTRY
Passes Database Connection Services directory information
SQLA-FLAGINFO
Holds flagger information
SQLB-TBS-STATS
Returns additional table space statistics to an application program
SQLB-TBSCONTQRY-DATA
Returns container data to an application program
SQLB-TBSPQRY-DATA
Returns table space data to an application program
SQLCA
Returns error information to an application
SQLCHAR
Transfers variable length data between an application and the database manager
SQLDA
Transfers collections of data between an application and the database manager
SQLDCOL
Passes column information to the IMPORT and EXPORT APIs
SQLE-ADDN-OPTIONS
Passes information to the ADD NODE API
SQLE-CONN-SETTING
Specifies connection setting types and values
SQLE-NODE-APPC
Passes information for cataloging APPC nodes
SQLE-NODE-APPN
Passes information for cataloging APPN nodes
SQLE-NODE-CPIC
Passes information for cataloging CPIC nodes
SQLE-NODE-IPXSPX
Passes information for cataloging IPX/SPX nodes
SQLE-NODE-LOCAL
Passes information for cataloging LOCAL nodes
SQLE-NODE-NETB
Passes information for cataloging NetBIOS nodes
SQLE-NODE-NPIPE
Passes information for cataloging named pipe nodes
SQLE-NODE-STRUCT
Passes information for cataloging nodes
SQLE-NODE-TCPIP
Passes information for cataloging TCP/IP nodes
SQLE-REG-NWBINDERY
Passes information for registering/deregistering the DB2 server in/from the bindery on the NetWare file server
SQLE-START-OPTIONS
Holds the database manager start-up options
SQLEDBCOUNTRYINFO
Transfers country information between an application and the database manager
SQLEDBDESC
Passes creation parameters to the CREATE DATABASE API
SQLEDBSTOPOPT
Holds the database manager stop options
SQLEDINFO
Returns a copy of a single directory entry from the system or local database directory
SQLENINFO
Returns a copy of a single directory entry from the node directory
SQLFUPD
Passes configuration file information
SQLM-COLLECTED
Transfers Database System Monitor collection count information between an application and the database manager
SQLM-RECORDING-GROUP
Transfers Database System Monitor monitor group information between an application and the database manager
SQLMA
Sends database monitor requests from an application to the database manager
SQLOPT
Transfers bind parameters to the BIND API and precompile options to the PRECOMPILE PROGRAM API
SQLU-LSN
Contains the definition of the log sequence number used by the ASYNCHRONOUS READ LOG API
SQLU-MEDIA-LIST
Holds a list of target media (BACKUP) or source media (RESTORE) for the backup image. Also used for the import, export and load APIs.
SQLU-RLOG-INFO
Contains information regarding a call to the ASYNCHRONOUS READ LOG API
SQLU-TABLESPACE-BKRST-LIST
Provides a list of table space names
SQLUEXPT-OUT
Transfers export information between an application and the database manager
SQLUHINFO
Used by the recovery history file APIs to return information from the recovery history file
SQLUIMPT-IN
Transfers import information between an application and the database manager
SQLUIMPT-OUT
Transfers import information between an application and the database manager
SQLULOAD-IN
Transfers load information between an application and the database manager
SQLULOAD-OUT
Transfers load information between an application and the database manager
SQLUPI
Contains partitioning information, such as the partitioning map and the partitioning key of a table.
SQLXA-RECOVER
Used by the transaction APIs to return a list of indoubt transactions
SQLXA-XID
Used by the transaction APIs to identify a transaction.


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

[ DB2 List of Books | Search the DB2 Books ]