DATABASE

DATABASE

Specifies the SYSTEM 2000 database to use

Required statement

Applies to: access descriptor

Syntax
Details

Syntax

DATABASE<=>database-name S2KPW<=>password <MODE<=>access-mode>;

Details

The DATABASE statement specifies the name of the SYSTEM 2000 database that you want to access, its password, and optionally the access mode. The DATABASE statement should immediately follow the CREATE statement for the access descriptor being created.

The database name can be one to 16 characters long. Names longer than 16 characters will be truncated without an error message. If the database name contains blanks or special characters, enclose the name in single or double quotes.

The database password, submitted with the S2KPW argument, determines the picture of the database that can be used to create view descriptors. For information about acceptable passwords, see SYSTEM 2000 Passwords.

The syntax for the S2KPW argument is:

S2KPW<=>password

The password can be one to four characters long, with no embedded blanks, and optionally enclosed in single quotes. Passwords longer than four characters will be truncated with a warning message. If you specify a special character for a password, it must be a single character (that is, a one-character password) and enclosed in single quotes. This argument is required.

The syntax for the MODE argument is:

<MODE<=> SINGLE|MULTI>

The MODE argument specifies your mode of accessing SYSTEM 2000 software. SINGLE means the database is in a single-user environment (that is, a database in your SAS program environment). MULTI means the database files are in the Multi-User environment. The default value is MULTI. The SINGLE value can be abbreviated as SU or S. The MULTI value can be abbreviated as MU or M.

DB, DBN, and S2KDB are aliases for the DATABASE statement.

Chapter Contents
Previous
Next
Top of Page