DATABASE=

DATABASE=

Specifies the DBD name of the IMS-DL/I database on which this 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-DL/I database on which this 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-DL/I 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 Access Descriptors for tools that SAS Institute supplies to automate the database definition process. [cautionend]

Arguments

The following list explains the arguments 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-DL/I Database Types for a description of each database type. You can use DBT= as an alias for DBTYPE=.

DBTYPE= tells the IMS-DL/I 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

database=acctdbd dbtype=hisam;

Chapter Contents
Previous
Next
Top of Page