This piece of SQL was brought to my attention by a friend who works with Db2 for z/OS (mainframe). He said that at times he uses what I am going to explain to validate that the data he inserted into Table has the values he expected.
He refers to it as “Select final table”, which will be the name I am going to use for it. I did find this referred to in the IBM Documentation web site, there is a link to this page at the bottom of this post. The Db2 for z/OS version has more functionality than one for Db2 for i. This has me puzzled, why they are not the same?
With Db2 for i “Select final table” can only be used with a SQL Insert subselect. It returns the rows that were inserted into the table.
The Table, TESTTABLE, I will be using in these examples has two columns:
Read more » Read More
Display event – N2i: Getting Started with HA/DR members.common.org
When
9/18/2023 4:30 PM – 5:30 PM Read More
How LANSA BI brings real-time insights to IBM i applications LANSA Editors
With data becoming a strategic asset for many organizations around the globe, more and more business owners are turning to BI solutions to extract valuable insights and make informed decisions. BI tools not only facilitate the consolidation and analysis of large datasets from multiple sources, but also enable users to identify potential revenue streams or
The post How LANSA BI brings real-time insights to IBM i applications appeared first on LANSA. Read More
Cleanup After Failed STRFSFLASH
This document provides options to the user in the event that a STRFSFLASH process fails to complete successfully Read More
CTXiUG meeting tomorrow! RPGPGM
You don’t want to miss this: 📅TOMORROW – Tue Sept 12 @ 6:30 PM (CT) 📢Raspberry Pi & #IBMi 🗣️Andy Youens, IBM Champion 💰Online & free 🌐https://ctxiug.blogspot.com/ #IBMi #IBMiLUG #AS400 https://preview.redd.it/51c1apcaqmnb1.png?width=631&format=png&auto=webp&s=73e0a2a8325e2aab419a084fd11dccf115e4bea3 submitted by /u/RPGPGM[link][comments] Read More
