Chapter Contents

Previous

Next

S2KPW

Optional statement
Applies to:	view descriptor

Details

The S2KPW statement specifies a SYSTEM 2000 password and optional access mode for creating a view descriptor. The password you specify will be stored in encrypted form and enable all who access the view descriptor to have access to the data it describes. If you do not specify the S2KPW statement when creating a view descriptor, you must specify the password when using the view descriptor to access data from the database.

The password used when you open a view descriptor determines the data you see and your ability to subset and edit it through the view descriptor. You can specify the password used in the access descriptor from which the view is derived, or another password that encompasses a subset of its data. If you specify a password that does not encompass data from the access descriptor, the view will be created, but the software will issue an error message when you attempt to open it.

The password specified in the S2KPW statement 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.

The S2KPW statement takes one optional argument, as follows:

MODE <=> SINGLE|MULTI

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.

MD, S2KMD, and S2KMODE are aliases for the MODE argument. The mode is also stored with the view.

Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.