/* 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;
Refreshing SPD Server Parameter and LIBNAME
Files
The REFRESH Command
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.
REFRESH Command Examples
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'
REFRESH Command Examples
215
Содержание Scalable Performance Data Server 4.5
Страница 1: ...SAS Scalable Performance Data Server 4 5 Administrator s Guide...
Страница 7: ...Part 1 Product Notes Chapter 1 SPD Server 4 5 Product Notes 3 1...
Страница 8: ...2...
Страница 12: ...6...
Страница 63: ...Part 3 Migration Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility 59 57...
Страница 64: ...58...
Страница 70: ...64 Chapter 5 SPD Server 3 x to SPD Server 4 5 Conversion Utility...
Страница 72: ...66...
Страница 76: ...70 Chapter 6 Using the SPD Server Name Server to Manage Resources...
Страница 94: ...88 Chapter 7 Administering and Configuring SPD Server Using the SAS Management Console...
Страница 98: ...92 Chapter 8 SPD Server SQL Query Rewrite Facility...
Страница 116: ...110 Chapter 10 Configuring Disk Storage for SPD Server...
Страница 128: ...122 Chapter 11 Setting Up SPD Server Parameter Files...
Страница 154: ...148...
Страница 198: ...192 Chapter 14 ACL Security Overview...
Страница 212: ...206 Chapter 15 Managing SPD Server Passwords Users and Table ACLs...
Страница 214: ...208...
Страница 224: ...218 Chapter 16 SPD Server Operator Interface Procedure PROC SPDO...
Страница 236: ...230 Chapter 18 SPD Server Table List Utility Spdsls...
Страница 256: ...250 Chapter 19 SPD Server Backup and Restore Utilities...
Страница 264: ...258 Chapter 20 SPD Server Directory Cleanup Utility...
Страница 270: ......