Search

Sidebar

Home

MC Press Online

01

Sat, Apr

8 New Articles

1. Free-Format RPG: Printing Without O-Specs or an Externally Defined Printer File: (RPG); IBM has made just about everything in free-format RPG truly free-format…except O-specs. But you can print without needing an externally defined printer file. By Sam Lennon Instead of adding free-format ...; Created on 01 August 2022
2. Introducing Free-Format RPG IV, Part 3: (RPG); Programming Style Issues By Jim Martin Editor's Note: This article is excerpted from chapter 4 of Free-Format RPG IV: Third Edition, by Jim Martin. Many books and articles have covered the subject ...; Created on 01 July 2022
3. Introducing Free-Format RPG IV, Part 2: (RPG); Free-Format Operation Codes By Jim Martin Editor's Note: This article is excerpted from chapter 4 of Free-Format RPG IV: Third Edition, by Jim Martin. Table 4-1 lists the 62 operations that free-format ...; Created on 31 May 2022
4. Introducing Free-Format RPG IV, Part 1: (RPG); For those new to free format, getting started is sometimes the toughest part. By Jim Martin Editor's Note: This article is excerpted from chapter 4 of Free-Format RPG IV: Third Edition, by Jim Martin. ...; Created on 26 April 2022
5. Getting Started: Free vs. Fixed and Internal Documentation in ILE RPG Programming: (RPG); Part three of getting started ILE RPG program addresses free vs. fixed and internal documentation. Read parts one and two here: Getting Started: Sections & a Sample of ILE RPG Programs and here: Getting ...; Created on 13 January 2022
6. Getting Started: Building the ILE RPG Program and Navigating Legacy Code: (RPG); Part two addresses the building of an ILE RPG program. It also demonstrates how to navigate legacy code. Review Part one here: Getting Started: Sections & a Sample of ILE RPG Programs. By Brian Meyers ...; Created on 04 January 2022
7. Getting Started: Sections & a Sample of ILE RPG Programs: (RPG); Part one addresses the introduction to the sections of an ILE RPG program. It also illustrates how to write a simple file read/write program by using a procedural approach, as well as how to include comments ...; Created on 08 December 2021
8. Diving Deeper into RPG /Free: (RPG); ... off the ground. By David Shirey Editor's Note: This article is excerpted from chapter 4 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. I am taking it slow to start with. I want to show ...; Created on 06 July 2021
9. Capstone RPG & DB2 Summit Conference Announced for October 2021: (Certification / Training); System i Developer to turn focus to other forms of training System i Developer announces today that its 2021 Virtual RPG & DB2 Summit, scheduled for October 20-26, will be its final conference-style ...; Created on 15 June 2021
10. Why /Free in RPG?: (RPG); Why should you use /Free? Certainly positional RPG is familiar to everyone in our world. Why bother to learn or use /Free? Fortunately, there are a ton of articles out there about the advantages of /Free, ...; Created on 04 May 2021
11. ILE RPG Prototyping Primer Keywords: (RPG); ... Note: This article is excerpted from chapter 15 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey. In an earlier excerpt, we explored ILE RPG's prototype structure. Now let's look at PR- and PI-specific ...; Created on 09 March 2021
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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
21. 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
22. Practical RPG: Encapsulating Your Data with Extension Files, Part 4: (RPG); ... that comes with a file specification (F-spec), you need to explicitly define the field yourself. Without rehashing the article, it depends on whether you're using ILE RPG or RPG/400, but either way you'r ...; Created on 01 May 2020
23. SQL 101: Using ILE RPG Functions as SQL UDFs: (SQL); It’s now time to get to know SQL user-defined functions and see how they can encapsulate your RPG code. By Rafael Victória-Pereira Although RPG stands for Report Program Generator, over the years, ...; Created on 06 April 2020
24. 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
25. SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 2: (SQL); Now that you can tell SPs from UDFs, let’s find out how to create RPG-infused stored procedures, step by step. By Rafael Victória-Pereira In the previous TechTip, I (very briefly) introduced Persistent ...; Created on 04 March 2020
26. 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
27. Practical RPG: Encapsulating Your Data with Extension Files, Part 3: (RPG); ... opposite of what I want! So instead, I prefer to use templates. Unfortunately, this works only in ILE; we'll see the more primitive way we have to do this in RPG/400 a little later in the article. Bu ...; Created on 28 February 2020
28. SQL 101: Using ILE RPG Programs and Procedures as SQL Stored Procedures, Part 1: (SQL); ... parameters, as you’ll see in a later article of this series. In this and the next articles, I’ll focus on SPs and how they can be used to encapsulate RPG procedures or programs. First of all, what ...; Created on 11 February 2020
29. 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
30. Practical RPG: Encapsulating Your Data with Extension Files, Part 2: (RPG); ... standard RPG I/O opcodes such as CHAIN and UPDATE. Updates to an extension file are usually localized to a small number of programs. When you're first creating an extension file, it tends to consist ...; Created on 30 January 2020
31. SQL 101: Flipping It—Using RPG Code in SQL: (SQL); It’s time to learn how to (and why) you can “flip” things around by putting RPG code inside SQL “things.” The how is easier than you might think, but the why will blow your mind! By Rafael Victória-Pereira ...; Created on 15 January 2020
32. 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
33. Practical RPG: Encapsulating Your Data with Extension Files, Part 1: (RPG); Extension files allow you to extend the life of your database without having to completely re-engineer it. By Joe Pluta As business programmers, we spend most of our time working with the database, ...; Created on 07 January 2020
34. SQL 101: Embedding Other SQL Statements in Your RPG Code: (SQL); They say a picture is worth a thousand words. I say that, sometimes, a single DELETE SQL statement is worth a thousand lines of RPG code. Let me show you how…and why. By Rafael Victória-Pereira You’ve ...; Created on 09 December 2019
35. Practical RPG: Moving Your Help to Panel Groups: (RPG); The HLPARA keyword is a great first step to providing help, but HLPPNLGRP provides your users with next-level support. See them in play here. By Joe Pluta In my previous article, I described the underlying ...; Created on 03 December 2019
36. 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
37. 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
38. Practical RPG: Putting Help in Context: (RPG); Display file DDS supports powerful ways to provide contextual help text to your users…but with limitations. Learn how to get around those limitations. By Joe Pluta IBM supports a wide range of help-related ...; Created on 31 October 2019
39. Practical RPG: Service Programs—When: (RPG); Service program procedures are great when called by applications, and even better when they call each other. By Joe Pluta Previous articles covered the why and how of service programs: wonderful bundles ...; Created on 26 September 2019
40. 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
41. Practical RPG: Service Programs—How: (RPG); ... identifies one of those areas where ILE programming and ILE RPG in particular is definitely not object-oriented in nature. In a true object-oriented programming (OOP) environment, you could have multiple ...; Created on 03 September 2019
42. 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
43. Practical RPG: Service Programs–Why?: (RPG); ... have noticed that I used the keyword *DCLCASE on the EXTPROC statement. That will force the procedure name Convert to be declared to the rest of the system in mixed case. The default in RPG is to uppercase ...; Created on 29 July 2019
44. 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
45. 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
46. 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
47. 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
48. SQL 101: Embedding SQL in RPG Code, Part 2: (SQL); ... in both fixed- and free-format RPG code. I also demonstrated the functionality provided by host variables, which allow SQL and RPG to exchange information in a simple and easy-to-implement way. Let’s continue ...; Created on 12 March 2019
49. 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
50. Introduction to Runtime Arrays in ILE RPG: (RPG); Get to know the runtime array, a handy structure for storing data used during an ILE RPG program’s execution by Bryan Meyers and Jim Buck Editor’s Note: This article is excerpted from chapter 11 of ...; Created on 05 February 2019

MC-STORE.COM