Working with Databases

Go Up to API Guide

This chapter describes how to set up a database parameter buffer (DPB) that specifies database attachment parameters, how to set up and initialize database handles, and how to use the five API functions that control database access. It also explains how to set up item request and return buffers prior to retrieving information about an attached database.

The following table lists the API functions for working with databases. The functions are listed in the order that they typically appear in an application.

API Database Functions

Call	Purpose
isc_expand_dpb()	Specifies additional parameters for database access, such as user names and passwords elicited from a user at run time; requires a populated DPB and allocates a larger block for the DPB it returns
isc_attach_database()	Connects to a database and establishes parameters for database access, such as number of cache buffers to use; uses a previously declared and populated DPB
isc_database_info()	Retrieves requested information about an attached database, such as the version of the on-disk structure (ODS) that it uses
isc_detach_database()	Disconnects from an attached database and frees system resources allocated to that attachment
isc_drop_database()	Deletes a database and any support files, such as shadow files

Topics

• Connecting to Databases
• Requesting Information About an Attachment (API Guide)
• Disconnecting from Databases
• Deleting a Database
• Alphabetical List of DPB Parameters

Advance To:

• Connecting to Databases