SAS Safety Scalable Performance Data Server 4.5 Manual Do Utilizador

/* verify the contents of the created table */

PROC CONTENTS data=&domain..staceys_table ;
run;

/* SPDO Truncate command deletes the table */
/* data but leaves the table structure in */
/* place so new data can be appended */

PROC SPDO lib=&domain;
 SET acluser;
 TRUNCATE staceys_table;

 quit;

/* verify that no rows or data remain in */
 /* the structure of staceys_table */

PROC CONTENTS data=&domain..staceys_table;
 run;

You can use PROC SPDO to dynamically refresh SPD Server parameter and LIBNAME
files. If you make changes to your spdsserv.parm file or to your libnames.parm environment
file for SPD Server, you can use the REFRESH command to avoid restarting the server.
Submitting the REFRESH command refreshes the specified SPD Server file without
restarting the server.

When you submit the REFRESH command, SPD Server refreshes the operating parameter
file.

The syntax for the REFRESH command to refresh the libnames.parm file is:

REFRESH DOMAINS

The syntax for the REFRESH command to refresh the spdsserv.parm file is:

REFRESH PARMS

Each REFRESH operation completely refreshes and replaces the contents of the previous
libnames.parm file or the spdsserv.parm file in the SPD Server environment.

Add a new LIBNAME domain to your current libnames.parm file and use it without
restarting the server:

LIBNAME spds44 sasspds 'spds44'
        server=estore.5180
        user='admin'