Some #ansible on #ibmi links added to the #ibmireference webpage ibmireference.blogspot.com/p/ibm-i-ansibl…
– Torbjörn Appehl (@tappehl)12:19 – Mar 08, 2023
Are you concerned about increasing threats in the IT world? Join us on March 15th for a #webinar on taking a holistic approach approach to #IBMi security and learn how to protect your customers’ personal data & company information effectively.
Are you concerned about increasing threats in the IT world? Join us on March 15th for a #webinar on taking a holistic approach approach to #IBMi security and learn how to protect your customers’ personal data & company information effectively. okt.to/0gW2MC pic.twitter.com/oK3jYpm24O
– Julie Skeen (@juliekskeen)12:51 – Mar 08, 2023
Copying data with an Identity column from one table to another and not change the value
It has always been a problem with copying data from one SQL DDL table to another if the table contains an identity column. Identity columns are controlled by the database itself. When a new row is inserted into the table the database assigns the Identity column in the new row the next sequence number. They are a great way to ensure that the table has a unique key, and they can be shared with other files as an external key to link back to the original table.
The issue has always been that if I copy data from one table to another with an Identity column of the same name the database will assign the inserted rows new identity values using the sequence of the copied to table. This has been a great frustration to us all, and has led to many forsaking Identity columns altogether.
Debug RPGLE and COBOL with VS Code for IBM i
Our Twitter feeds recently rang out with this long-awaited news from Liam Allan: “Debugging ILE COBOL and RPGLE inside @code like it’s any other day! I’m pumped for this release #ibmi.” As reported by Alex Woodie in IBM i Debugger Comes to VS Code, IBM decoupled their RPG/COBOL debugger from RDi after years of encouragement from Liam. It’s now available as a Debug Service to the thousands of IBM i developers who have downloaded Visual Studio Code for IBM i. In the following video, Liam demos how to use Code for IBM i’s Walkthrough utility to set up and start the…
The post Debug RPGLE and COBOL with VS Code for IBM i appeared first on Seiden Group.
20230323 – NHMUG March 2023
New Hampshire IBM i User Group Meeting
Thursday, March 23 2023 – Fireside Inn, West Lebanon NH
We know it’s been a while since you’ve heard from NHMUG. But we haven’t forgotten about you.
We are going to try a live event again. So come join us in West Lebanon NH at the Fireside Inn on Thursday, March 23rd.
This time however, we are going to add a twist. We will have three sessions with three different IBM speakers.
This event is free to IBM i professionals, and sponsored by NHMUG with assistance by our friends at IBM.
We are presently having an issue with our Registration system. To register please send a email to [email protected] include the Name, company, number of attendees and email addresses of all attending.
Sessions will include:
IBM i OS 7.5
In this session Steven Fier will give an update on IBM i 7.5 and an overview of the latest and greatest tools you can gain from migrating to the latest OS version.
Updating your systems to a Power 10
Todd Boyd will speak on as you upgrade your servers there is becoming a greater focus on sustainability. Todd will show you the necessary upgrade paths and the associated core/system energy reductions and how this can lower your total ROI. Including a roadmap overview of some of the latest hardware announcements.
Securing Remote Db2 Access
Robert Andrews will discuss the topic that is in the forefront of everyone’s mind. Security for your database is not a one and done item. There are many ways to access your system’s data from a remote connection. This session explores some of the most popular remote data access methods and discusses the various security aspects of each one. Topics covered include passwords, encryption, and exit points.
