@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)

​@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 

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 

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 

Verified by MonsterInsights