SPDO Procedure

Example 3: Refreshing SPD Server Domains

Features:

REFRESH DOMAINS statement

Details

This example shows how to activate a new domain without having to stop and restart the server. In this example, domain RefTest is a pre-existing domain. The new domain is RefTest2. Both domains have OWNER=ADMIN set in their definitions in the libnames.parm parameter file.
Connect to the server and execute PROC SPDO with the REFRESH DOMAINS statement using an existing domain. In the LIBNAME statement, specify the ACLSPECIAL= LIBNAME option. Set the user context to the domain owner by using the SET ACLUSER statement.
libname mylib sasspds 'reftest'
server=d8488.5180
user='admin'
password='spds123'
aclspecial=YES;

proc spdo library=mylib;
SET acluser admin;
REFRESH DOMAINS;
quit;
Reconnect to the server and specify the RefTest2 domain.Domains that have an OWNER= option such as RefTest2 must be reconnected to the domain.
libname mylib2 sasspds 'reftest2'
server=d8488.5180
user='admin'
password='spds123';
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017