Re: Set SQL variable from select

On Thu, Jan 29, 2026 at 10:42 AM Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

I have this statement:

WITH MYJOB AS(
(select JOB_NAME
from table(
QSYS2.active_job_info(
job_name_filter => ’SOMEJOB',
subsystem_list_filter => 'QSYSWRK'
)
)))

I keep getting errors creating the variable MYJOB which will be used a bit
later in the SQL. Says end of statement error. If I add “with data” that
dies with not expected. So how do I get the results from the query into
the variable MYJOB? (Only one row should be returned)

Try this:

WITH myjob AS (

SELECT JOB_NAME

FROM

TABLE(

QSYS2.active_job_info(

job_name_filter => 'SOMEJOB',

subsystem_list_filter => 'QSYSWRK'

)

)

)