To define an SPD Server
domain in the libnames.parm file, you must define the domain as a
LIBNAME and define the path that points to the directory in which
data files for the domain are stored.
LIBNAME=domain-name PATHNAME=primary-metadata-path
<optional specifications>
OPTIONS="option-1 <...option-n>"
ROPTIONS="option-1 <...option-n>"
OWNER=owner-id
LIBACLINHERIT=<YES/NO>
DYNLOCK=<YES/NO> ;
The domain name that
is associated with the LIBNAME must follow standard SAS LIBNAME nomenclature
rules. The PATHNAME= specification defines the computing path that
will contain the metadata tables that are associated with the domain.
By default, the PATHNAME= specification will also contain the data
tables, index tables, and intermediate tables that the domain creates.
SPD Server administrators and users can use the options described
in
Domain Path Options
to enhance computational performance by specifying separate paths
for domain data, index, and work tables. All SPD Server domain names
must be unique. Different SPD Server domains should never share the
same domain path.
Here are some examples
of simple libnames.parm file domain declarations:
LIBNAME=spds123 PATHNAME=c:\data\spds123;
LIBNAME=123spds PATHNAME=c:\data\123spds;
LIBNAME=_under PATHNAME=c:\data\_under;
LIBNAME=under_ PATHNAME=c:\data\under_;
The libnames.parm file
is the preferred method to declare domains for use in SPD Server.
Users can connect to domains by submitting SAS code to SPD Server
after a session has started. The following example SAS code connects
to the first domain in the previous example:
LIBNAME spds123 sasspds 'spds123'
server=d8488.5200
user='anonymous';