There are a multitude of ways to check the IBM i OS version on your IBM i System (No it is NOT an AS400 or iSERIES machine – Don’t argue. Don’t!) You can do it from Control Language Programs You can do it from RPG programs You can do it from SQL You can do Read More
POWERUp 2023 Promo COMMON
POWERUp 2023The COMMON community will gather again in-person to enjoy learning high quality IBM i education, networking with peers, industry experts, and solution providers, and growing together as a whole.Mark your calendars for April 24-27 to join COMMON for education, networking, and scenic views in the Mile High City – Denver!For more information: https://www.common.org/powerup2023/home 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
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
[Webinar] VS Code and IBM i – Git Makes it Work Miki Laurent
Join us to see VS Code as an editor of native IBM i code and learn about the extensions that make this possible.
The post [Webinar] VS Code and IBM i – Git Makes it Work appeared first on ARCAD Software. Read More
