The SQL Procedure

DISCONNECT Statement

Ends the connection with a DBMS that is supported by a SAS/ACCESS interface.

Requirement: SAS/ACCESS software is required. For more information on this statement, refer to your SAS/ACCESS documentation.

See also: Connecting to a DBMS Using the SQL Procedure Pass-Through Facility

DISCONNECT FROM dbms-name|alias;

alias: specifies the alias that is defined in the CONNECT statement.
dbms-name: specifies the DBMS from which you want to end the connection (for example, DB2 or ORACLE). The name you specify should match the name that is specified in the CONNECT statement.

An implicit COMMIT is performed before the DISCONNECT statement ends the DBMS connection. If a DISCONNECT statement is not submitted, implicit DISCONNECT and COMMIT actions are performed and the connection to the DBMS is broken when PROC SQL terminates.
PROC SQL continues executing until you submit a QUIT statement, another SAS procedure, or a DATA step.

Requirement:	SAS/ACCESS software is required. For more information on this statement, refer to your SAS/ACCESS documentation.
See also:	Connecting to a DBMS Using the SQL Procedure Pass-Through Facility