Set SQL variable from select

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)

Since I am barely adequate with SQL I don’t see the answer and searching has been of no help.
--
Jim Oberholtzer
Agile Technology Architects