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

Products

• CA Automic Workload Automation - Automation Engine

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