Get empowered with IBM Power
Let’s get back to the basics. These sessions are designed for anyone starting out as an IBM i system admin, looking to refresh their knowledge, or looking to learn more.
…
The post iBasics: Basics of PTFs first appeared on iTech Solutions Group.
We’re continuing to provide bite-sized technical sessions to help make your workday easier. Join Nathan Williams as he covers Shortcuts, Tips, and Time Savers in IBM i Access Client Solutions.
In this presentation, we will examine:
…
The post Sips & Tricks: Shortcuts, Tips, and Time Savers in IBM i Access Client Solutions first appeared on iTech Solutions Group.
A small enhancement to the Object Statistics table function in the latest round of Technology Refreshes is going to make it easier for me to get the results I want. Previously if I wanted to get the results for a group of objects I would have to ask the table function for a list of all the objects in the library, and then limit the returned results only to the ones I want using a where clause.
SELECT OBJNAME,OBJTYPE,OBJATTRIBUTE
FROM TABLE(QSYS2.OBJECT_STATISTICS(
OBJECT_SCHEMA => ‘MYLIB’,
OBJTYPELIST => ‘*ALL’,
OBJECT_NAME => ‘*ALL’))
WHERE OBJNAME LIKE ‘TEST%’
ORDER BY OBJTYPE,OBJNAME ;
I am sure you can appreciate that this is not the most efficient way to get the results I want, a list of objects that start with the letters: TEST. I have had to return the results of all the objects in the library MYLIB, and then select from that list the rows I want, where the name start with TEST.
These recommendations are based upon your system already having installed the most current Cumulative PTF Package, HIPER PTF Group, and Database PTF Group.
Requesting a personalized demo is a great next step for seeing the benefits of Sequel Data Access for your business needs: https://www.helpsystems.com/cta/request-live-sequel-data-access-demonstration
Sequel keeps getting better and better. Want to see what we’ve rolled out recently and get a hint of what’s to come?
Take a quick 30 minutes with your favorite Sequel software experts as we bring you up to speed on the latest features and enhancements you may have missed, including:
-Improved overall dashboard performance
-Updated Dashboard Designer menu options when adding new objects
-New way to submit Client Reports without relying on old Windows servers
With Sequel, we strive to develop and refine a modern data access and business intelligence tool for your organization. If you’re not already taking advantage of the latest enhancements, we can’t wait for you to try them! Make sure to stick around for the Q&A!
Watch now!
