ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Resolving a SQLI as bind parameter within another SQLI does not work
book
Article ID: 87484
calendar_today
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Error Message : N/A
When a SQLI is used as a bind parameter in another SQLI, it returns 0 rows.
Example:
VARA.SEC_SQLI.NESTED_VARA - Notice that column {2} for UC_CLIENT_SETTINGS is 1000003
<Please see attached file for image>
When used as a Bind Parameter, the SQL returns 0 rows.
Use VARA.SEC_SQLI.NESTED_VARA as a parameter in VARA.SEC_SQLI.LIST_STATIC_VARA_VALUES.
{VARA.SEC_SQLI.NESTED_VARA,UC_CLIENT_SETTINGS,2} returns 0 rows when it should be returning 1000003
<Please see attached file for image>
Cause
Cause type: Defect Root Cause: Nested variables with type SEC_SQLI did not work if variable is used within {} expression as bind-parameters. Preview did not return any result.