Pass-Through Facility: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

DISCONNECT Statement

Terminates the connection to the data source.

Valid in:

PROC SQL steps (when accessing PC files data using SAS/ACCESS software)

Syntax
Arguments
Details
Example

Syntax

DISCONNECT FROM PCFILES |<alias>

Arguments

alias: specifies an alias for the connection that was defined in the CONNECT statement.

Details

The DISCONNECT statement ends the connection with the data source. If the DISCONNECT statement is omitted, an implicit DISCONNECT is performed when PROC SQL terminates. The SQL procedure continues to execute until you submit a QUIT statement, another SAS procedure, or a DATA step.

Any return code or message that is generated by the data source is available in the macro variables SQLXRC and SQLXMSG after the statement executes. See Return Codes for more information about these macro variables.

Example

After connection and SQL processing, this example uses the DISCONNECT statement to disconnect the connection from the database and the QUIT statement to quit the SQL procedure:

DISCONNECT FROM PCFILES;
QUIT;

Top of Page