[[{“value”:”Inscription: Save the Date: 10/10/24- Itheis , avec la participation d’IBM France, organise de nouveau iBelieve 2024, avec la gestion des projets de transformation au coeur de l’evenement
L’article i Believe 2024 est apparu en premier sur Itheis | Modernisation des bases et applications IBM i AS400.”}]] Read More
Webinar Raz-Lee Right to the Point: Reporting LIVE DEMO Raz-Lee Security
Participate and learn how to get the best out of Reporting on iSecurity Suite. This Webinar is a Live Demo with one of our support experts.This 30 minutes webinar covers:Flexibility in creating running a report or a queryThe Run Audit Query (RUNAUQRY)Creating ReportsReporting GroupScheduling Reports Read More
Db2 for i, Under the Covers TechChannel
IBM software engineer Ryan Moeller on SQE, AQP, query optimization and the rewards of interacting with the IBM i communityFrom: TechChannel Read More
Extra columns in a Select statement but not in the group by [email protected] (Simon Hutchinson)
[[{“value”:”I struggled with the title of this post to make it something that explains the content, without it being too long. I am not limited for length in the body of this post so I can explain in more detail my scenario: I want to have columns that are listed in my results for a Select statement that are not in the GROUP BY clause.
This is something that has been made easier with a new Scalar function added in the latest round of Technology Refreshes. First let me give you examples of my scenario.
What I am going to do is to take use my PERSON DDL Table and make a count of the places of birth of the people. As these are people from the British Isles, I will also include the columns for the county and the country (England, Ireland, Northern Ireland, Scotland, or Wales) from a second Table, TOWN.
Read more »”}]] Read More
Power Systems Firmware check Chris Hird
We have just added a couple of new checks to the AAG product that will allow system administrators to quickly see when IBM releases new firmware updates / upgrades. There are 2 types of firmware Read More
