Unable to resolve variable that is embedded in a VARA.SQLI object

Article Id: 87385

Status: Published

Updated On: 15-04-2018 08:05

Legacy Id: 000008945

Products:

CA Automic Workload Automation - Automation Engine , AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction:

Error Message :
N/A

The SQLI variable is not resolving script variables when using PREP_PROCESS_VAR with a Key.

Investigation

1) Create a SQLI variable with a variable in the select statement ex:

select EH_Name as Name,
EH_AH_Idnr as Run_Num,
EH_Status as Status,
EH_OType as Obj_Type,
EH_StartTime as StartTime
from EH where EH_Client = '100' and
EH_Name like '&SID#%'

2) Call this from a PREP_PROCESS_VAR using a key ex:

:SET &HND1# = PREP_PROCESS_VAR(PRB00117608.SQLI, &JOB#)

3) Nothing will be processed.

Cause:

Cause type:
Defect
Root Cause: PREP_PROCESS_VAR does not work when a FILTER is used. If used, variables within the SQL-statement are not resolved.

Environment:

OS Version: N/A

Resolution:

Update to a fix version listed below or a newer version if available.

Fix Status: Released

Fix Version(s):
Automation Engine 12.0.0
Automation Engine 11.2.2
Automation Engine 11.1.4

Additional Information:

Workaround :
Use SEC_SQLI