SQL Variables Parameters

Systemwide variables that contain the relevant parameters for SQL variables.

SQLVAR_INTERNAL

• Description: Determines who can create and edit SQL - internal and SQL - internal SECURE Variable objects.

  For security reasons, the creation of Variable objects of these types is deactivated by default because the execution of SQL statements on the AE database enables systemwide access to objects and other data. Important data records can also be modified or deleted.

  Note: The internal SQL variables that are supplied by default in client 0 are not affected by this setting and can always be used.

• Allowed values: YES and NO

  YES: Allows users to create, edit, and use internal SQL variables on a system-wide basis. To do so, a user must have the Create and modify SQL-Internal variables privilege.

  NO: Objects cannot be created anymore. The variable type SQLI is no longer listed in the Templates dialog (new object).

• Default value: NO

• Restart required: No

SQLVAR_MAX_ROWS

• Description: Defines the maximum number of lines to be retrieved by Variable objects with the source SQL and SQLI.

  The maximum number of rows must be equal or higher than the number of agents in use. Otherwise, the an error message is displayed.

  Example

  Job Status: FAULT_OTHER - Start impossible. Other error.

  Message: U00003900 Error in object 'PCK.AUTOMIC_FILESYSTEM.PUB.ACTION.CREATE_DIR' (RunID '0001358760') prompt 'PCK.ITPA_SHARED.PRV.PROMPTSET.OVERWRITE_AGENT': Invalid value.

  Note: This setting does not have any effect on variables of the types Filelist and Multi.

• Allowed values: 0 to 500000

  If you specify a very high value it may take longer to resolve Variable objects.

• Default value: 200

• Restart required: No

See also:

• UC_SYSTEM_SETTINGS - Systemwide Settings
• Granting Automation Engine Authorizations