DATABASE= Statement

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

Type:	Required statement
Applies to:	access descriptor

Syntax

Required Argument

Details

Syntax

DATABASE=database-name DBTYPE=database-type;

Required Argument

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. 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.

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.

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

An example of the DATABASE= statement is as follows:

database=acctdbd dbtype=hisam;