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

Document ID : KB000087385
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.

 
Environment:
OS Version: N/A
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.
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