Unable to resolve variable that is embedded in a VARA.SQLI object
Article ID: 87385
Updated On:
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:
2) Call this from a PREP_PROCESS_VAR using a key ex:
3) Nothing will be processed.
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#%'
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.
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
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
Use SEC_SQLI
Feedback
Powered by
