Variable Attributes

The following overview lists the attributes of a Variable object and describes their functions, allowed values and ways of modification.

Predefined variables may be used in scripts, and script variables may be set to attributes retrieved via predefined variables.

Variable Tab for VARA.SQL and VARA.SEC_SQL

Column

Attribute

Value

Access Via:

Connection

SQL_CONNECTION

User-defined,
maximum 200 characters

Change Program

Login

SQL_LOGIN

User-defined,
maximum 200 characters

Change Program

Bind parameters are the same for both secure SEC_SQL and SEC_SQLI types.

Both internal SQLI and SEC_SQLI types offer different statement fields for all three supported AE database types (MSSQL, Oracle, DB2) – whereas the external SQL types (SQL and SEC_SQL only offer one statement field)

Preview and script access are always there for all types.

See also:

Automation Engine DB Change