Workload Group shortcut added to Active Job Info

One of the SQL table functions I use the most is the ACTIVE_JOB_INFO, which is used to list all of the active jobs in any partition.

In IBM i TR4 and 7.3 TR10 a new parameter, DETAILED_INFO, was added to the Table Function. This controlled the number of columns that were returned in the results. When it was introduced there were the following options

— Default
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO()) ;

— All columns returned
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘ALL’)) ;

— QTEMP info returned only
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘QTEMP’)) ;

— Minimum info
SELECT * FROM TABLE(QSYS2.ACTIVE_JOB_INFO(DETAILED_INFO => ‘NONE’)) ;
Read more »

Sequel | Make the Most of Sequel with Browser Based Data Access

If you’re interested in learning more and would like to participate in a trial, click here: https://www.fortra.com/products/enterprise-data-access-software-ibm-i/sequel-web-interface/download-trial

You already know and love the flexibility of Sequel Data Access. You can run queries on the fly, create top-notch reports, and build dashboards your users love.

The only problem is that your business users want to explore data on their own. But you don’t want to install Viewpoint on everyone’s desktop… much less teach them all to use green screens.

Take 30 minutes to learn how to:

-Give users access to IBM i data anytime, anywhere
-Let executives view KPIs on the go
-Lighten the load on IT

All possible with Sequel Web Interface! Plus, we’ll show you how easy mobile data access can be.

Watch now!

Verified by MonsterInsights