Month: March 2023

​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 

​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 

​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 

​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 

​@php_dave @Forstie_IBMi Ctrl-R will run the SQL statement the cursor is currently located in…Shift-Ctrl-R will run _from_ that statement and the following statements.Shift-Ctrl-A will run ALL statements from the start of the script.#IBMi- Christian Jørgensen (@ChrJorgensen) (in reply to php_dave)14:05 – Mar 22, 2023 Read More