Pass-Through Facility: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
Terminates the connection to the data source.
Valid in: |
PROC SQL steps (when accessing PC files data
using SAS/ACCESS software)
|
DISCONNECT FROM PCFILES |<alias>
|
- alias
-
specifies an alias for the connection that was defined in
the CONNECT statement.
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.
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;
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.