SQL Query Action Icon

Close SQL Connection

 

Declaration

<AMSQLCLOSECONNECTION SESSION="Text" />

See Also

Open SQL Connection | SQL Query | Stored Procedure | Web Service | FTP (File Transfer Protocol) | HTTP (Hypertext Transfer Protocol) | MSMQ (Microsoft Message Queuing) | Microsoft SharePoint

Description

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

Practical Usage

Used to terminate a previously opened SQL session.

Parameters

General Properties

Property

Type

Required

Default

Markup

Description

Session Name

Text

Yes

SQLSession1

SESSION="SQLSession2"

Specifies the session name of the SQL connection to close.

 

Description Properties

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

Error Causes Properties

The Error Causes tab is part of AutoMate'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

On Error Properties

The On Error tab is part of AutoMate'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

Additional Notes

Variables and Expressions

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.

More on variables
More on expressions
More on the expression builder

Example

NOTE: The code below can be copied and pasted directly into the Steps pane of the Task Builder.

 

Description: Close SQL connection open in session "SQLSession2".  

 

<AMSQLCLOSECONNECTION SESSION="SQLSession2" />

 

↑ Top of Page