Re: Set SQL variable from select

[David Gibbs <david@xxxxxxxxxxxx>]

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'

)

)

)