- 1. RPG Academy: UI Modernization, Part 7 - Rational Open Access Vendors
- (RPG)
- Let’s continue to discuss Rational Open Access: RPG Edition and its most well-known vendors. By Rafael Victória-Pereira If you read the previous TechTip, you should know by now that Rational Open Access: ...
- Created on 29 January 2021
- 2. RPG Academy: UI Modernization, Part 6 - Introducing Rational Open Access
- (RPG)
- Rational Open Access: RPG Edition, formerly known as RPG Open Access, is a valuable tool in any modernization initiative. Let’s start exploring it in this TechTip. By Rafael Victória-Pereira There ...
- Created on 04 January 2021
- 3. RPG Academy: UI Modernization, Part 5 - From ILE to MVC, Explained
- (RPG)
- ... of the program. These service programs would provide data access functions, in the form of RPG or SQL I/O Servers, designed to read and write records to the database. Service programs INVBL, ORDBL, and ...
- Created on 30 November 2020
- 4. RPG Academy: UI Modernization, Part 4 - MVC Layers Explained
- (RPG)
- ... SQL view is built over existing database tables. Data Access Object Tables (DAOTs) are implemented as RPG service programs with external procedure definitions that are accessible from the DAOV. The ...
- Created on 02 November 2020
- 5. RPG Academy: UI Modernization, Part 3—Introducing the MVC
- (RPG)
- ... are less likely to break the presentation layer, and conversely, that changes to the presentation layer are less likely to break the business logic. Where the modular approach allowed several RPG programmers ...
- Created on 02 October 2020
- 6. RPG Academy: UI Modernization, Part 2—Multi-Tier Architecture Implementations
- (RPG)
- ... functions, in the form of RPG or SQL I/O servers, designed to read and write records to the database. Service programs INVBL, ORDBL, and CLIBL would supply higher-level procedures and functions like ...
- Created on 27 August 2020
- 7. RPG Academy: UI Modernization, Part 1 - Laying the Foundations
- (RPG)
- ... that goal I’m also thinking about including a brief explanation of RPG Open Access and some tools that use this great RPG enhancement to facilitate the modernization of a legacy application’s UI. Let’s ...
- Created on 03 August 2020
- 8. RPG Academy: Database Modernization - Methodology, Part 10
- (Analytics & Cognitive)
- ... difference: a ROWID operand cannot be directly compared to any data type. To compare the bit representation of a ROWID in SQL, you must first cast the ROWID to a character string. In RPG, there is no data ...
- Created on 29 June 2020
- 9. RPG Academy: Database Modernization - Methodology, Part 9
- (RPG)
- Let’s explore another of DB2’s advanced functionalities: the identity column. This is one of the most interesting and simultaneously least-used functionalities of DB2. Keep reading to find out how to use ...
- Created on 01 June 2020
- 10. RPG Academy: Database Modernization - Methodology, Part 8
- (RPG)
- Now that you’ve streamlined your database, gotten rid of unnecessary columns and/or tables, and moved all or at least part of the data validation code out of your programs, you’re ready to dive a little ...
- Created on 01 May 2020
- 11. RPG Academy: Database Modernization - Methodology, Part 7
- (RPG)
- ... starting with its header, available here. As you can see, everything has comments and is carefully organized, as a modern RPG piece of code should be. Note that there’s a function for each operation. ...
- Created on 30 March 2020
- 12. RPG Academy: Database Modernization - Methodology, Part 6
- (RPG)
- ... to accomplish the task based on performance, personal understanding and other pertinent factors. For single record operations, the built-in RPG operations may still offer as good or better performance ...
- Created on 03 March 2020
- 13. RPG Academy: Database Modernization—Methodology, Part 5
- (RPG)
- Time to start discussing the second big step in our database modernization methodology: moving business rules to the database. It’s going to be an interesting trek, and I hope you join me in it! By Rafael ...
- Created on 31 January 2020
- 14. RPG Academy: Database Modernization—Methodology, Part 4
- (RPG)
- Today’s topic is normalization. If your database were a piece of dirty laundry, normalization would be a kind of wash-rinse-dry process. But in this case, shrinking wouldn’t be a problem. By Rafael Victória-Pereira ...
- Created on 07 January 2020
- 15. RPG Academy: Database Modernization - Methodology, Part 3
- (RPG)
- ... add the RCDFMT keyword with the DDS record format name to ensure your RPG programs are still able to use the table/file as they did before. Logical files present different challenges. If the logical ...
- Created on 03 December 2019
- 16. RPG Academy: Database Modernization—Methodology, Part 2
- (RPG)
- ... I talk about the actual DDS-to-DDL conversion process in the next TechTip. Here’s what I usually use for the “new” short name of the file, which will be recognizable by the existing RPG programs: PF ...
- Created on 04 November 2019
- 17. RPG Academy: Database Modernization - Methodology, Part 1
- (RPG)
- ... the previous TechTip, for instance. Don’t do it! Legacy application databases are often a collection of seemly unrelated flat files, connecting to each other via the RPG programs that use them. There’s ...
- Created on 03 September 2019
- 18. RPG Academy: Database Modernization - Tools to Help the Modernization Process
- (Programming - Other)
- Some Entity Relationship Diagrams (ERDs) are simple, while others are really complex. This article describes a few tools that can help you tackle both types of ERDs, as well as everything in between. By ...
- Created on 31 July 2019
- 19. RPG Academy - Database Modernization: Entity Relationship Diagrams
- (General)
- For some, Entity Relationship Diagrams (ERDs) are old friends that you still visit once in a while and have some fun with. For others…not so much. Let’s try to help the latter get up to speed on ERDs. ...
- Created on 02 July 2019
- 20. RPG Academy - Database Modernization: A Bit of Database Theory
- (General)
- Let’s kick off this new subseries of RPG Academy with a review of database theory. You might already know a few of these things, but these concepts are crucial to the rest of this series on database modernization. ...
- Created on 04 June 2019
- 21. RPG Academy - Modernization: Guidelines for Modernization Goals, Part 3
- (RPG)
- ... and business users, respectively), over the existing application, there’s a hidden bonus: your company will end up with a revitalized application and a group of people who know a lot about it! RPG Academy ...
- Created on 29 April 2019
- 22. RPG Academy - Modernization: Guidelines for Modernization Goals, Part 2
- (RPG)
- ... by the application and displays it in a nicer UI. This is particularly useful when you no longer have access to the application’s source code and want to modernize it. RPG Open Access—If you still have ...
- Created on 02 April 2019
- 23. RPG Academy - Modernization: Guidelines for Modernization Goals, Part 1
- (RPG)
- Having an idea of how to set reasonable modernization goals is not enough. So if the last article left you wanting more, this one will provide. By Rafael Victória-Pereira Now that we’ve looked at a ...
- Created on 04 March 2019
- 24. RPG Academy – Modernization: Setting Your Modernization Goals
- (RPG)
- Crafting your own map, knowing (and preparing for) the perils you’ll encounter is important, but you also need to define where you want to go. So set your modernization goals wisely! By Rafael Victória-Pereira ...
- Created on 31 January 2019
- 25. RPG Academy - Modernization: Tips to Avoid the Pains of Modernization
- (RPG)
- There’s no accurate map for a modernization initiative, so the best you can do is go into the “Here be dragons” part of it a little more prepared. By Rafael Victória-Pereira Modernization is usually ...
- Created on 04 January 2019
- 26. RPG Academy - Modernization: Let’s Talk About the Benefits
- (RPG)
- ... functions from RPG functions can be particularly useful in this type of situation: you just need to port the business rules validation code to stored procedures/user-defined functions and have the external ...
- Created on 29 November 2018
- 27. RPG Academy—Modernization: Is Your Application Worth Modernizing?
- (RPG)
- This is the big question you should ask yourself before starting a modernization process, because sometimes it’s better (and cheaper) to quit and start over. By Rafael Victória-Pereira You probably ...
- Created on 05 November 2018
- 28. RPG Academy – Modernization: Is Restructuring the Database the Way to Go?
- (DB2)
- ... the “RPG Academy” article series provided and by writing structured, modular, and easier-to-maintain code. The TechTips of this modernization series thus far should have given you a solid foundation for ...
- Created on 23 July 2018
- 29. RPG Academy – Modernization: Why, What, Where, and How
- (RPG)
- It’s time to start discussing modernizing your IBM i applications. This new subseries of RPG Academy presents some questions to ask yourself and offers some answers. by Rafael Victória-Pereira The ...
- Created on 17 July 2018
- 30. RPG Academy: Debug Done Right – Debugging Batch Jobs
- (RPG)
- ... it’s actually quite simple. For your convenience, here’s a list of the previous article in the series, in the order in which they appeared: RPG Academy: Debug Done Right - Introducing the ILE Debugger ...
- Created on 28 June 2018
- 31. RPG Academy: Debug Done Right - A Step-by-Step Debug Session, Part 2
- (RPG)
- Let's continue our debug session where we left off and learn a few more debug tips and tricks! Written by Rafael Victoria-Pereira In order to get the most out of this TechTip, you'll need to read or ...
- Created on 25 April 2018
- 32. RPG Academy: Debug Done Right - You Can Debug Anything!
- (RPG)
- With the ILE Debugger, you can debug anything. This TechTip will explain how to debug service programs, OPM RPG, and CL programs! By Rafael Victoria-Pereira You already know it's possible to debug a ...
- Created on 25 January 2018
- 33. RPG Academy: Debug Done Right - A Step-by-Step Debug Session, Part 1
- (RPG)
- ... modules should be familiar by now, but if you have any questions, refer to chapter 7 of IBM's ILE Programmer's Guide, Creating a Program with CRTRPGMOD and CRTPGM. There, you'll find everything you need to ...
- Created on 02 January 2018
- 34. RPG Academy: Debug Done Right - Working with Watch Conditions
- (RPG)
- Knowing your way around a debug source and knowing how to set and remove breakpoints is very important, but sometimes you need more than that. That’s where watch conditions come into play. By Rafael ...
- Created on 30 October 2017
- 35. RPG Academy: Debug Done Right - Working with Breakpoints
- (RPG)
- Now that you know how to start a debug session, let’s see how to set and use breakpoints. This is one area where the “new” ILE debugger is way better than the “old” STRDBG. By Rafael Victória-Pereira ...
- Created on 29 August 2017
- 36. RPG Academy: Debug Done Right - Starting a Debug Session
- (RPG)
- Now that you know the debug views at your disposal and learned how to encrypt your debug views, it’s time to start a good and proper debug session with the ILE Debugger. By Rafael Victória-Pereira Once ...
- Created on 27 June 2017
- 37. RPG Academy: Debug Done Right - Encrypting Your Debugging Views
- (RPG)
- Good news for RPG shops everywhere: IBM gave us a way to protect our code from prying eyes, while keeping all the functionality of the debug views! The code is there, but it’s hidden. Written by Rafael ...
- Created on 01 May 2017
- 38. RPG Academy: Debug Done Right - Choosing the Right Debug View
- (RPG)
- ... I won’t detail each of OPTION’s possible keyword here; please refer to IBM’s ILE RPG Programmer’s Guide, Appendix D - Compiler Listings for more information. I intentionally saved the two ends of the ...
- Created on 04 April 2017
- 39. RPG Academy: Debug Done Right - Introducing the ILE Debugger
- (RPG)
- ... so you’re probably no stranger to the Interactive Source Debugger (ISDB) that has served RPG programmers since V3R1. Now that you’re moving into the brave new world of ILE, it’s also time to upgrade your ...
- Created on 28 February 2017
- 40. RPG Academy: Write Better Code - More on Commenting and Documenting Strategies
- (RPG)
- This TechTip will continue to discuss the documentation topic, focusing on the tools that an RPG programmer has available and offering a few tips to help define a proper documentation strategy (even if ...
- Created on 03 January 2017
- 41. RPG Academy: Write Better Code - Commenting and Documenting Strategies
- (RPG)
- Usually, programmers don’t comment their code appropriately, for a variety of reasons: “I don’t have the time,” “My code speaks for itself,” etc. Mostly, they simply hate doing it. Let me try to refute ...
- Created on 06 December 2016
- 42. RPG Academy: Write Better Code - More Tips for Organizing Your Modules and Service Programs
- (RPG)
- The previous article of the series discussed module and service program organization. It’s now time to do the same for binding directories. Written by Rafael Victória-Pereira Let’s start with a quick ...
- Created on 01 November 2016
- 43. RPG Academy: Write Better Code—Tips for Organizing Your Modules and Service Programs
- (RPG)
- It’s important to keep in mind that the naming conventions are not limited to variables, procedures, and files. Since you’re starting with ILE and building your first modules and service programs, this ...
- Created on 04 October 2016
- 44. RPG Academy: Write Better Code - Naming Conventions for Physical and Logical Files
- (RPG)
- ... exceed the maximum length of an RPG field name. The number of characters in the name to be prefixed must not be less than or equal to the value represented by the “number of characters to replace” parameter. ...
- Created on 06 September 2016
- 45. RPG Academy: Write Better Code — Choosing Appropriate Names for Variables, Procedures, and Functions
- (RPG)
- ... to camel case. Speaking of long names, did you know that the maximum length allowed by RPG for a variable is 4,096 characters? While it doesn’t make any sense whatsoever to even consider using such ...
- Created on 02 August 2016
- 46. RPG Academy: Write Better Code—A Few More Naming Variables Guidelines
- (RPG)
- ... by Rafael Victória-Pereira The last installment of this series covered parameter and work variable prefixes, which are arguably the most-used variables in a typical RPG program. However, I recommend ...
- Created on 05 July 2016
- 47. RPG Academy: Write Better Code – Naming Variables Guidelines, Part 1
- (RPG)
- This subseries of RPG Academy focus on ways to improve your code’s efficiency, readability, and maintainability. In other words, it will help you write better code. Written by Rafael Victória-Pereira ...
- Created on 31 May 2016
- 48. RPG Academy: /FREE Your Code - Convert Fixed-Format Code to Free-Format, Part 3
- (RPG)
- The last two TechTips provided some insights about the process of converting RPG “classic” code to free-format. This one covers a topic often overlooked, but extremely important: handling arrays. Written ...
- Created on 03 May 2016
- 49. RPG Academy: /FREE Your Code - Converting Fixed-Format Code to Free-Format, Part 2
- (RPG)
- ... which will certainly require some time to properly convert to free-format. When it comes to comparing stuff, RPG’s options go well beyond other languages; most languages don’t have anything like ...
- Created on 06 April 2016
- 50. RPG Academy: /FREE Your Code - Convert Fixed-Format to Free-Format, Part 1
- (RPG)
- ... of operation codes are a peculiarity of RPG. IBM decided that they do more harm than good (quite rightfully, in my opinion), so they were left out of free-format for the sake of readability and likeness ...
- Created on 01 March 2016