AnsweredAssumed Answered

Passing variables to SQLI/SQL VARA objects...

Question asked by Chuck_Williams_313 on Feb 3, 2014
Latest reply on Feb 16, 2017 by Michael_Lowry

Is there a way to pass a variable into a SQLI/SQL VARA object?

I want to be able to do something like:

select 

ah_client as Client, 

ah_idnr as RunID, 

ah_runtime Runtime, 

ah_archive1 as Database,

ah_archive2 as Build_Type,

ah_timestamp1 as Activation_Time, 

ah_timestamp2 as Start_Time, 

ah_timestamp4 as End_Time, 

ah_status as Status

from AH 

where AH_OH_Idnr in (select OH_idnr from OH where OH_Name='&TASK_NAME#') 

and ah_runtime > 0 

and ah_client='1100'

order by ah_archive1, ah_timestamp1

Outcomes