Chapter Contents

Previous

Next
SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

Data Set Options

Data set options allow you to override some of the run-time options that are stored in view descriptors. Two options are currently available: S2KPW= and S2KMODE=. You can use these as data set options on SAS PROC statements.

The options specified with the DATA= argument on a PROC statement override those stored in a view descriptor.


Description

S2KPW=password
allows you to override the SYSTEM 2000 password stored in the view descriptor. If no password is stored in the view descriptor, the S2KPW= option must be used to provide a valid password for the database.

The password must be an alphanumeric value one to four characters long with no embedded blanks, optionally enclosed in single quotes. Passwords longer than four characters will be truncated with a warning message. If the password is a special character, it must be a single character (that is, a one-character password) enclosed in single quotes.

S2KPW= is an option on the DATA= argument where DATA= specifies a SYSTEM 2000 view descriptor that will be used as input to a SAS procedure other than the DBLOAD procedure. (Passwords specified in the DBLOAD procedure cannot be overridden.)

S2KMODE|S2KMD=S|M
allows you to override the SYSTEM 2000 access mode stored in the view descriptor. M means the database files are allocated in a region controlled by the Multi-User software. S means you are executing the procedure as a single-user job, where you allocate the database files in your job and execute a separate copy of SYSTEM 2000 software.

S2KMODE= is an option for the DATA= argument where DATA= specifies a SYSTEM 2000 view descriptor that will be used as input to a SAS procedure other than the DBLOAD procedure. (The DBLOAD procedure uses the mode specified for a new database or stored in the view descriptor for an incremental load.)

S2KMD= is an alias for S2KMODE=.


Data Set Option Syntax

You can specify the S2KPW= and S2KMODE= data set options with the DATA= argument on any PROC statement except PROC DBLOAD. They are effective for that single execution of the procedure. Data set options will override the corresponding values stored in the view descriptor.

The following example executes the FSEDIT procedure using a view descriptor named EMPPOS. The data set options specified in the PROC statement will execute SYSTEM 2000 software in single-user mode, using the password DEMO.

proc fsedit data=vlib.emppos 
  (s2kmode=s s2kpw=demo);
run;


Chapter Contents

Previous

Next

Top of Page

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