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.

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.

Read more »

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

Verified by MonsterInsights