SPDO Procedure
- Syntax
Procedure SyntaxPROC SPDO StatementADD ACL StatementCLUSTER ADD StatementCLUSTER CREATE StatementCLUSTER DESTROY StatementCLUSTER FIX StatementCLUSTER LIST StatementCLUSTER MODIFY StatementCLUSTER REMOVE StatementCLUSTER REPLACE StatementCLUSTER UNDO StatementCONSTRAINT ADD StatementCONSTRAINT DESCRIBE StatementCONSTRAINT REMOVE StatementDELETE ACL StatementLIST ACL StatementLIST USERS StatementLIST USERS/LOCKING StatementMODIFY ACL StatementOPER StatementREFRESH DOMAINS StatementREFRESH PARMS StatementSET ACLTYPE StatementSET ACLUSER StatementSET MODE OPER StatementSET USER StatementSET USER/LOCKING StatementSHOWLIBNAME StatementSPDSCMD StatementSPDSMAC StatementTRUNCATE Statement - Overview
- Concepts
- Examples
SHOWLIBNAME Statement
Lists libref and table information for a connected user proxy.
| 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, LIST USERS/LOCKING, SET USER, SET USER/LOCKING, SET MODE OPER, and OPER statements to issue proxy commands. |
Syntax
SHOWLIBNAME options;
SHOWLIBNAME libref |
_ALL_;
SHOWLIBNAME libref /
DATA=[ _ALL_| table-name];
SHOWLIBNAME libref /
DUMP=[ _ALL_| table-name];
Details
-
Specify the SHOWLIBNAME statement with the _ALL_ option to see every currently assigned libref for the selected user proxy.
-
Specify the SHOWLIBNAME statement with a libref to list information about that specific libref.
-
Specify the SHOWLIBNAME statement with a libref and the /DATA=_ALL_ option to list open tables in the server connection.
-
Specify the SHOWLIBNAME statement with a libref and the /DATA=table-name option to list information about a specific table in the server connection.
-
Specify the SHOWLIBNAME statement with a libref and the /DUMP=_ALL_ option to list accessible tables in the libref’s server connection.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 3, 2017