Database - Close SQL connection
Declaration
<AMSQLCLOSECONNECTION SESSION="Text" />
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:
- Copy and paste the sample AML code below directly into the Task Builder Steps Panel.
- To successfully run the sample code, update parameters containing user credentials, files, file paths, or other information specific to the task to match your environment.
Description
Close SQL connection open in session "SQLSession2".
Copy
<AMDATABASE ACTIVITY="close_sql_connection" SESSION="DatabaseSession1" />