VARA Object Attributes

The following overview includes the attributes of VARA objects 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.

Variables Page for VARA.SQL and VARA.SEC_SQL

Connection

SQL_CONNECTION

Value: User-defined

Length: Max. 200 characters

Access through: Change program

Login

SQL_LOGIN

Value: User-defined

Length: Max. 200 characters

Access through: Change Program

Notes:

  • 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:

AE DB Change