Automation Engine Script Guide > Ordered by Function > Read or Modify Objects > GET_CONNECTION

GET_CONNECTION

Script Function: Reads information from a DB-type Connection object.

Syntax

GET_CONNECTION(Object name, Attribute)

Syntax

Description/Format

Object name

The name of a DB-type Connection object.
Format: AE name, script literal or script variable

Attribute

The value that should be read from the object.
Format: AE name, script literal or script variable

Allowed values:

Please note: The value DbUserid has to be used in case-sensitive databases exactly as printed here.

Return Codes

Required value of the CONN object.

Comments

This script function reads a certain value of a DB-type Connection object and returns it as code.

A runtime error occurs when the system cannot find the specified object, when it is not a DB-type Connection object or when the specified attribute is not valid.

Examples

The following example retrieved the database type of the Connection object CONN.DB and writes it to the activation report.

:SET &VAR#GET_CONNECTION(CONN.DB, db.type)
:&VAR#

This is how the related line appears in the activation protocol:

2013-01-30 12:45:21 - U0020408 MSSQL

 

See also:

Script Elements Description
GET_ATT This function returns the values of a task's attributes during the generation process.
GET_LOGIN Reads information from Login objects.