ACCESS Procedure Reference |
Stores the SYSTEM 2000 password and access mode for a view descriptor.
Applies to: |
view descriptors only
|
S2KPW=password MODE=SINGLE|MULTI|SU|MU|S|M;
|
The
S2KPW statement specifies the SYSTEM 2000 password and access mode for creating
a view descriptor. The password you specify is stored in encrypted form. It
enables 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 a password when using the view descriptor in order to access
data from the database.
The password that is used when you open a view descriptor
determines which data you see and your ability to subset and edit it through
the view descriptor. You can specify the password that was used in the access
descriptor from which the view is derived, or you can specify another password
that encompasses a subset of the data in the view descriptor. If you specify
a password that does not encompass data from the access descriptor, the view
is created, but the software issues an error message when you attempt to open
the view descriptor.
password can be 1 to 4 characters in length,
with no embedded blanks, and enclosed in single quotation marks. Passwords
longer than 4 characters are truncated and a warning message appears. If you
specify a special character for a password, it must be a single character
(that is, a 1-character password) and enclosed in single quotation marks.
You can use the following in the S2KPW statement:
-
MODE=SINGLE|MULTI|SU|MU|S|M
-
specifies the mode in which you want to
access SYSTEM 2000. SINGLE (SU or S) means that the database in your SAS program
environment is in single-user mode. MULTI (MU or M) means that the database
files are in Multi-User mode. The mode is also stored with the view. The default
is MULTI.
MD, S2KMD, and S2KMODE are aliases.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.