Blog

006 on the show today we have my good friend Brian Garland from Vermont Information Processing (VIP).   Brian has been a part of the IBM community since 1985 when he took a part-time job working on the System 34.  Brian is an Application Engineer, a lifelong resident of Vermont, loves reading science fiction, hiking and is a HUGE Star Trek fan.   Brian’s contact informationEmail: [email protected] Blog/personal site:  https://briangarland.devGithub page:  https://github.com/briangarlandStar Track:  https://www.startrektour.com/VIP WebsiteOne incredible Th(i)ng!  Products, gadgets, recipes, music or things we are loving right now.   Tony’s picks for this week: American comic book writer, artist and podcaster https://en.wikipedia.org/wiki/Donny_Cates Peg’s pick for the week:   Coffee – every which way!  Brian’s pick for the week: This was tough.  I guess I’d have to say sourdough starter.  I know a lot of people got into bread-making during the pandemic.  I didn’t start until just a few months ago.  The starter and some equipment were a Valentine’s Day gift from my wife.  I’ve made bread, pancakes, dinner rolls, and biscuits.  It’s a great compliment to the technical side of my life.  There are recipes to follow but you don’t have to be exact.  It’s peaceful just mixing ingredients and kneading dough.https://www.kingarthurbaking.com/Upcoming Events:COMMON iNISIGHT 2021 July 27-29 is an online learning opportunity with over 70 presentations.   And the best part – it is FREE to all COMMON members! POWERUp21 October 4-7 in Virginia Beach, VA.   This event is LIVE onsite and simulcast over the web.  Don’t forget to pack your swimsuit! This episode is sponsored by… COMMON https://www.common.org/home Midrange Dynamics Change Management Software – Built for IBM i modernization! https://www.midrangedynamics.com/   Interested in sharing your IBM i story?  Want to sponsor the podcast?  We want to hear from you!  Reach out to Peg at [email protected] 

…

The post iBasics: Basics of PTFs first appeared on iTech Solutions Group.

…

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.

Read more »

These recommendations are based upon your system already having installed the most current Cumulative PTF Package, HIPER PTF Group, and Database PTF Group.