TechChannel’s Rising Stars are shaping the future of #IBMi. How? Read these five key takeaways from a recent interview with three @jbuck_imPower students to learn more: hubs.ly/Q01HTXbb0- TechChannel (@TechChannelHQ)14:38 – Mar 22, 2023 Read More
If you’ve ever read my articles or books you know I’m a huge fan of implementing multiple layers of defense. Join me as I discuss why encryption may be the last line of defense for your #ibmi data. #ibmchampion Carol Woodbury (@carolwoodbury)
If you’ve ever read my articles or books you know I’m a huge fan of implementing multiple layers of defense. Join me as I discuss why encryption may be the last line of defense for your #ibmi data. #ibmchampion lnkd.in/ggE7dBy4- Carol Woodbury (@carolwoodbury)18:18 – Mar 22, 2023 Read More
The Path to an IBM i Career: Lessons from TechChannel’s Rising Stars
We couldn’t extract the content of this article. Here is the URL so you can access it:https://techchannel.com/SMB/3/2023/path-to-ibm-i-career-rising-stars Read More
Find the most recent rows for a repeating sets of data with SQL [email protected] (Simon Hutchinson)
This post is based upon something I needed to provide to my superiors at my work. We have a history file that contains many thousands of repeating sets records (yes, I know it is time to purge the old data), I was asked to “create a SQL statement” that would return the most recent records for each key. It will make more sense when I show the data I am going to be using here. In these examples the file is named TESTFILE, and contains three columns of data. I can use the following SQL statement to list the contents of this file: 01 SELECT * FROM TESTFILE The results are: Read more » Read More
(3) SQL is a great data accessing tool – in most cases Status is offline
For test 5 the data needed – customer number being the key plus the wanted four rows – was loaded into a user index that is accessed instead of the standard Customer data base.
Each test run reads a customer data base ten million times using a generated “random” customer number as key. Read More