Join our chief architect @Steve_Will_IBMi on June 30th as he shines some headlights on the road ahead for software development on IBM i. Register here: bit.ly/2TYT0sX
– Brandon Pederson (@BPED07)10:00 – Jun 11, 2021
IBM i & IBM Power Grundkurs
Datum 18 – 22 Oktober
Kostnad 25.000 SEK ex Moms (10% Rabatt för medlemmar i Common Sweden & Common Norge)
Kursen sker online
Anmälan genom mail till torbjorn@builtonpower.com
Innehåll i kursen:
AGENDA
- Introduction
- IBM Power and IBM i history
- IBM i architecture from System/38 to IBM i
- Operating systems, Licensed Internal Code and the integrated database
- Command structure, menus and prompting
- Demo – Menu structure and help functions
- User profiles & authorities
- Communication, terminals, printers etc.
- Console, system startup / IPL
- Power Systems, hardware, storage
- Virtualization, PowerVM and related software
- Installation of IBM i & licensed programs
- PTF management
- Programming languages, compilators and applications
- Management interfaces, ACS & iNavigator
- Authority / security
- Job management, job queues, out queues
- CL-Programming
- Backup/BRMS
Huvudlärare är gurun Gunnar Elmgren
Specialistlärare CL-Programmering är Åke H Olsson
Bakgrund och historia körs av Torbjörn Appehl
#hmc for #ibmi may be on it final generation… #Power10 may not require an #hmc
#hmc for #ibmi may be on it final generation… #Power10 may not require an #hmc pic.twitter.com/BlFpXvuZtF
– SQL iQuery for #IBMi (@sqliquery)05:35 – Jun 15, 2021
Getting to message queue data faster
Prior to the latest round of Technology Refreshes for 7.4 and 7.3 if I wanted to get the data from a particular message queue I would need to use the MESSAGE_QUEUE_INFO SQL View. Being a View it contains all the data from all of the message queues, not just the one I would be interested. If I wanted to retrieve the messages from one message queue it would take a while for the results to be found and returned.
There is now a MESSAGE_QUEUE_INFO Table function. Table functions are faster than Views as they are sort of like an API, I pass the message queue name to the Table function and only that message queue is searched for the information I want.
The results returned by the View and Table function are almost identical. The only difference is that the View returns columns for the name of the message queue and the library it resides. As I pass that information to the Table function it is irrelevant to its results.
MESSAGE_QUEUE_INFO Table function has four parameters:
Drawing on decades of experience with #IBMi & #IBMPowerSystems, @Northdoorplc are getting together with some key IBM experts to bring you all the most important information & updates in our 2021 IBM i webinar.
Drawing on decades of experience with #IBMi & #IBMPowerSystems, @Northdoorplc are getting together with some key IBM experts to bring you all the most important information & updates in our 2021 IBM i webinar. northdoor.co.uk/join-our-ibm-i…
#IBMi pic.twitter.com/hQpvUjUEt1
– Northdoor plc (@Northdoorplc)02:42 – Jun 15, 2021
