SPDO Command Examples
1.
List the WORKPATH directory:
spdscmd 'ls /spdswork/*.spds';
spdscmd 'dir d:\spdswork\*.spds';
2.
Clean up WORKPATH files:
spdscmd 'rm /spdswork/*.spds';
spdscmd 'del d:\spdswork\*.spds';
LIBNAME Proxy Commands
Overview of Proxy Commands
To issue proxy commands, you must first select the SPD Server user proxy.
LIST USERS;
lists the proxy processes that are accessible to the PROC SPDO lib=<libname>
statement that was dispatched from the SPD Server host. Accessible proxies are
anonymous proxies and proxies that are owned by the LIBNAME owner. If the
LIBNAME owner has ACLSPECIAL privileges, then all user proxies will be listed.
SET USER userID [portnumber];
allows you to use the port number to distinguish between two proxies that share the
same user ID.
LIST USERS/LOCKING;
lists the user-locking proxy threads that are accessible by the PROC SPDO
lib=<libname> statement that was dispatched from the SPD Server host and that were
created with the LOCKING=YES LIBNAME option. Accessible proxies are
anonymous proxies and proxies that are owned by the LIBNAME owner. If the
LIBNAME owner has ACLSPECIAL privileges, then all user-locking proxies will be
listed. For each user-locking proxy thread, SPD Server returns the SPD Server user ID,
the client login, and the thread ID. You can select a user-locking proxy thread from the
LIST USERS list by submitting a command in the following form:
SET USER/LOCKING [userID threadID=#];
Once a user-locking proxy is selected, you can get LIBNAME information by
submitting the following commands:
SHOWLIBNAME libref | _ALL_;
SHOWLIBNAME libref / DATA=[ _ALL_| dsname];
SHOWLIBNAME libref / DUMP=[ _ALL_| dsname];
where libref is an explicit SPD Server LIBNAME name. Specify _ALL_ to see
every currently assigned LIBNAME for the proxy.
If the /DATA= option is used with _ALL_, information about all of the open tables
in the proxy for the given LIBNAME is displayed. If the /DATA= option is used
with a data set name dsname, detailed information about the specified data set table
is displayed.
If the /DUMP= option is used with _ALL_, information about all of the accessible
tables in the proxy for the given LIBNAME is displayed. If the /DATA= option is
210 Chapter 16 • SPD Server Operator Interface Procedure (PROC SPDO)
