DBN

DBN

Specifies the database to be created

Required statement

Applies to: New database

Syntax
Details

Syntax

DBN|DB= database-name;

Details

The DBN statement specifies the name of the database to be created. The database name must be a valid SYSTEM 2000 database name, from one to sixteen characters long. Database names longer than 16 characters will be truncated with no error message. If the database name contains embedded blanks or special characters, enclose it in single quotes. The slash (/), colon (:), and equal (=) special characters are not allowed.

This statement is required when you are creating a new database. A database with the same name must not already exist.

The software uses the first seven characters of the database name as part of the DDname for the database files. Any restrictions imposed by the operating system on DDnames also apply to the characters used in the database name.

For single-user jobs, you must allocate your files to your SAS session. For the Multi-User environment, the database files can be allocated when the Multi-User software is initialized or (Release 12.0 and later) the files can be dynamically allocated during execution using the ALLOC command.

DB= is an alias for the DBN= statement.

Chapter Contents
Previous
Next
Top of Page