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.