|
Well, if you really want to twist your head around something you can try this:
QSH CMD('db2 "SELECT COUNT(*) FROM qsys2.subsystem_info where status = ''ACTIVE'' and subsystem_description = ''QBATCH''" > /QSYS.LIB/ROB.LIB/ROBSQL.USRSPC')
Then install these commands to get RTVUSRSPC:
https://www.ibm.com/support/pages/creatingchangingretrieving-user-space-usrspc-ibm%C2%AE-iseries%E2%84%A2-family-servers
Too bad I couldn't get a pipe to a data area to work.
or this
QSH CMD('db2 "CREATE TABLE ROB.IFACTIVE AS(SELECT COUNT(*) AS JOBCOUNT FROM qsys2.subsystem_info where status = ''ACTIVE'' and subsystem_description = ''QBATCH'') WITH DATA"')
Then read that file with cl
Could not get the qtemp.ifactive to work. I suspect that qsh is spawned as a different job with it's own qtemp.
CL is such a kludge.
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.