Database - Close SQL Connection

Declaration

<AMSQLCLOSECONNECTION SESSION="Text" />

Related Topics    

Description

Closes a previously established connection created by an Database - Open SQL connection step and ends the session.

Practical Usage

Used to terminate a previously opened SQL session.

Parameters

General

Property Type Required Default Markup Description
Session Name Text Yes SQLSession1 SESSION="SQLSession2" Specifies the session name of the SQL connection to close.

Example

NOTE:
  • The sample AML code below can be copied and pasted directly into the Steps Panel of the Task Builder.
  • Parameters containing user credentials, files, file paths, and/or other information specific to the task must be customized before the sample code can run successfully.

Description

Close SQL connection open in session "SQLSession2".

Copy
<AMDATABASE ACTIVITY="close_sql_connection" SESSION="DatabaseSession1" />