Category: Feedly

​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 

​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 

​Don’t forget it is tonight!#IBMi #rpgpgm #IBMChampion twitter.com/ctxiug/status/…- Simon Hutchinson (@RPGPGM)07:15 – Mar 21, 2023Quoted Tweet:Do not miss this ⬇️📣@P_Behr🗣️ 2 presentations!📅 Later today (Tuesday March 21)⏰ 6:30 PM (US CT)🌐 ctxiug.blogspot.com🚫 Free to everyone#IBMi #IBMiLUG #AS400 pic.twitter.com/BN1l7B5hci- Central Texas IBM i User Group (@CTXiUG)07:00 – Mar 21, 2023 Read More 

​“I’m glad my employer put me through this course and I know couldn’t have self-taught myself a fraction of what Jim and Michelle teach.” – M. Bickish, Software DeveloperRead more: conta.cc/3lVTckZ #ibm #computing #impowertech #BuckU #SQL #IBMPowerSystems #RPGLE #IBMi- imPower Technologies (@jbuck_imPower)07:30 – Mar 21, 2023 Read More 

​Dave Willis, Connectria, and Jeremy Shearer, AWS, discuss how to modernize JD Edwards workloads running on IBM Platform into AWS. Check out the full video on YouTube ⬇️ bit.ly/3JphLV5 #AWS #hybridcloud #IBMi- Connectria (@Connectria)08:56 – Mar 21, 2023 Read More