(DI-2105) Collector for user defined SQL
Parameters
Following parameters are available for this collector:
Parameter name | Description |
---|---|
USE_BIND_VARIABLES | Should the SQL collector use bind variables when executing defined SQL statements? You might enable the bind variables by setting this value to 'X'. Default: empty (bind variables are not used by default) |
Bind variables
Collector for user-defined SQL supports also the usage of bind variables in SQL statement. To enable usage of bind variables, the parameter 'USE_BIND_VARIABLES' needs to be set for this collector.
- When enabled, all placeholders defined in the SQL statement are replaced by "?" and relevant variable values are transmitted.
- When no bind variables are enabled, all placeholders are replaced by the corresponding values directly in the SQL statement.
Support for bind variables
Before enablement of bind variables, always make sure that your primary database supports these binding variables "?" on the system, where a defined SQL statement is executed.