Closes a previously established connection created by an Open SQL Connection step and ends the session. Used to terminate a previously opened SQL session.
Declaration
<AMSQLCLOSECONNECTION SESSION="Text" />
Example
Close SQL connection open in session "SQLSession2".
<AMSQLCLOSECONNECTION SESSION="SQLSession2" />
See Also: Open SQL Connection, Execute SQL Query, Execute Stored Procedure, Execute Web Service, FTP, HTTP
|
Property |
Type |
Required |
Default |
Markup |
Description |
|
Session Name |
Text |
Yes |
SQLSession1 |
SESSION="SQLSession2" |
Specifies the session name of the SQL connection to close. |
The Description tab allows you to customize the text description of any step when it appears in the Steps Pane.
More on setting custom step description
The Error Causes tab is part of AWE's Error Handling functionality which allows you to select / omit specific errors that will cause a particular step to fail.
More about error causes properties
The On Error tab is part of AWE's Error Handling functionality which allows you to determine what the task should do if a particular step encounters an error.
More about On Error properties
All text fields allow the use of expressions, which can be entered by surrounding the expression in percentage signs (example: %MYVARIABLE%, % Left('Text',2)%). To help construct these expressions, you can open Expression Builder from these fields by pressing F2.