IMSTAT Procedure (Data and Server Management)

PURGETEMPTABLES Statement

The PURGETEMPTABLES removes all temporary tables from a server. The action requires server-level authorization because it removes temporary tables created by all users. To execute this command successfully, you must have the same authorization that is required to terminate the server.

Syntax
Without Arguments
PURGETEMPTABLES Statement Options

Syntax

PURGETEMPTABLES <options>;

Without Arguments

The server to use is identified from the active table. If you do not have an active table, then you can connect to a specific server with the HOST= and PORT= options.

PURGETEMPTABLES Statement Options

HOST="host-name"

specifies the host name for the server. Use this option with the PORT= option.

PORT=number

specifies the port number for the server.

Copyright © SAS Institute Inc. All rights reserved.