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: