Re: Executed QSYS2.QCMDEXC() in a loop in a cursor from JDBC. Can't stop loop

Justin,

Do you know SQL? (just kidding, ducking and running...)

On 7.2

SELECT AUTHORIZATION_NAME, JOB_NAME, SUBSYSTEM, JOB_TYPE,
SERVER_TYPE
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(
CURRENT_USER_LIST_FILTER => 'ROB')) X

....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
AUTHO00001 JOB_NAME SUBSYSTEM JOB_TYPE SERVE00001

ROB 977161/QTMHHTTP/ADMIN QHTTPSVR BCI
QIBM_HTTP_ADMIN
ROB 203207/ROB/ROBS1 QINTER INT -
******** End of data ********

http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqudfactivejobinfo.htm?lang=en-us

Notice how the first job listed does not have my name in the job name?

If you try this on 7.1
SQL0104 - Token => was not valid. Valid tokens: ) ,.

7.2 Knowledge Center has
IBM i 7.2>Database>Performance and query optimization>IBM i Services>Work
Management Services
7.1 stops at
IBM i 7.2>Database>Performance and query optimization

Check out the "What's new in DB2" on 12/15 offered free by COMMON.

Rob Berendt