SPDO Procedure

SET USER/LOCKING Statement

Connects to the locking proxy for the specified user ID and thread ID.

Requirement: You must have special privilege and specify ACLSPECIAL=YES in the LIBNAME statement to use this statement.
Interaction: Used in conjunction with the LIST USERS/LOCKING, SHOWLIBNAME, SET MODE OPER, and OPER statements to issue proxy commands.
See: SPD Server proxies are described in detail in Managing SPDSBASE Processes.
Syntax
Arguments
Details

Syntax

SET USER/LOCKING user-ID THREAD=thread-ID;

Arguments

user-ID

specifies a user ID returned by the LIST USERS/LOCKING statement.

THREAD=thread-ID

specifies the thread ID associated with the user ID.

Details

The SET USER/LOCKING statement is used after the LIST USERS/LOCKING statement in preparation for executing a proxy command. The LIST USERS/LOCKING statement identifies the locking users that are active in the connected domain. The SET USER/LOCKING statement enables you to connect to one of the listed user proxies.
After you have established a user connection with SET USER/LOCKING, you can issue the SHOWLIBNAMES statement to list the active librefs for the user and to get information about tables that are accessible or open in specific librefs. You can also use the SET MODE OPER and OPER statements to cancel, disconnect from, or interrupt the user proxy.
See Using PROXY Statements to Get Information about Locking SPD Server Users to see how this statement is used with other statements to issue a proxy command.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017