Real-world data from actual IBM i systems
The 2023 State of IBM i Security Study results are here to help you make the most of your time and resources. Read More
IBM i Update: April 2023 Rob Spivey
Watch the Video: Your #IBMi update for April 2023, delivered by Andy Nicholson: A snapshot of news and views on what’s been happening in the IBM i community in the past four weeks as reported by Proximity. Or Read the Details: Your #IBMi update – a snapshot of news and views on what’s been happening in the
The post IBM i Update: April 2023 appeared first on Proximity. Read More
The stratospheric cloud Elizabeth Coles
Webinar Perspectives on cloud first strategies, mission-critical applications, and the speciality cloud
When Luke Howard woke each morning, he would scan the sky for clouds in all their infinite variety. As an amateur meteorologist, he had good reason to keep such a devoted watch. And his 1803 book, The Modification of Clouds delivered to weathermen everywhere is still the go to for the classification of clouds. But what would he make of the digital cloud terminology of today? Read More
Easy way in SQL to insert records from one file that are not in the other Simon Hutchinson
In this scenario there are two files with identical field names, and they have the same data types too. I was asked if there is an easy way, using SQL, to insert all records from one file into a second file, omitting records that match ones that are in the second file.
I wanted to come up a solution where I did not have to give any field/column names in the statement. For all I knew the files in questions had many, many field names.
I created a file, I called FILE1, with four fields. Then I used the Create Duplicate Object command, CRTDUPOBJ, to create a duplicate, which I called FILE2.
FILE1 contained four records, which I can show using the following SQL statement:
Read more » Read More
POWERUp 2023 Industry Experts COMMON
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?For more information: https://www.common.org/powerup2023/home Read More
