ACCESS Procedure Reference

DATABASE= Statement

Specifies the DBD name of the IMS database on which the access descriptor is based.

Required statement
Applies to:	access descriptor

Syntax
Details
Arguments

Syntax

DATABASE=database-name DBTYPE=database-type;

Details

The DATABASE= statement specifies the DBD name of the IMS database on which the access descriptor is based. DBD= is an alias for the DATABASE= statement. If you are creating an access descriptor, the DATABASE= statement must be the first statement after the CREATE= statement.

For logical databases, the access descriptor definitions are mapped to the logical DBD (database description) and not to one or more physical DBDs. This enables the IMS engine to build correct database calls and for the SSAs (segmented search arguments) to navigate the logical structure of the database.

Note: See Tools for Creating IMS Access Descriptors for tools that SAS supplies to automate the database definition process. [cautionend]

Arguments

The following list explains the argument that can appear in a DATABASE= statement for an access descriptor:

DBTYPE= |DBT=

specifies the type of database and is required with the DATABASE= statement. Valid database types are HDAM, HIDAM, HSAM, HISAM, GSAM, SHSAM, and SHISAM. See IMS Database Types for a description of each database type. You can use DBT= as an alias for DBTYPE=.

DBTYPE= tells the IMS engine how to handle WHERE clauses that generate SSAs for database calls. If you omit DBTYPE= from your DATABASE= statement, you receive the following error:

ERROR 22-322: Expecting one of the following: 
DBTYPE = NAME. The statement is being ignored.

ERROR: Must enter database name first.

An example of the DATABASE= statement is as follows:

database=acctdbd dbtype=hisam;

Top of Page