02
Thu, Jan
0 New Articles
  1. You are here:  
  2. Home
  3. Search

Total: 3549 results found.

Search for:
Search Only:

Page 2 of 71

51. 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
52. 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
53. 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
54. 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
55. 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
56. Programming In ILE RPG
(MC Press Bookstore)
  Since its original publication, Programming in RPG IV has given thousands of students and professionals a strong foundation in the essentials of business programming using RPG IV. Now, the long-awaited ...
Created on 26 March 2020
57. 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
58. 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
59. 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
60. 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
61. 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
62. 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
63. 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
64. 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
65. 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
66. 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
67. 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
68. 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
69. 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
70. 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
71. 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
72. 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
73. 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
74. 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
75. 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
76. 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
77. 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
78. 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
79. 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
80. 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
81. 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
82. 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
83. 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
84. SQL 101: Embedding SQL in Your RPG Code, Part 1
(SQL)
SQL 101 is back, and it’ll help you bring your SQL code into your RPG programs. By Rafael Victória-Pereira RPG is not (and never will be) the focus of this series, but sometimes a bit of SQL can help ...
Created on 16 January 2019
85. 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
86. Practical RPG: A National Language Support Shortcut
(RPG)
... of the returned data, it's time to call the API. That's done with a single line of RPG code: QMHRTVM( dsCPX8416: %size(dsCPX8416): 'RTVM0100': 'CPX8416':          'QCPFMSG   *LIBL': ' ': 1: '*NO': '*NO': ...
Created on 04 January 2019
87. Practical RPG: QUSLOBJ, the Next Level of Object Information Retrieval
(RPG)
...  received extensive coverage over the years, but today's article will, as I always try to do, enhance that coverage into the modern world of free-format RPG. All list APIs work like this: Create  ...
Created on 30 November 2018
88. 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
89. RPG & DB2 Summit Heads to Charlotte, NC in March
(Certification / Training)
Adds new sessions on SQL, analytics and data integration System i Developer today announces its first RPG & DB2 Summit in Charlotte, NC, March 26-28, 2019 at the Hilton Charlotte University Place. The ...
Created on 28 November 2018
90. ILE RPG Tutorial: Using CALLP to Call an ILE Program
(RPG)
Learn how to use a prototyped call, an alternative to an ILE RPG sub-procedure, to call one program from another by David Shirey Editor’s Note: This article is excerpted from chapter 8 of 21st Century ...
Created on 07 November 2018
91. Practical RPG: Using QUSROBJD in Free-Format RPG
(RPG)
... books to use to access the API. They're pretty barebones; they provide very simple definitions of the data structures that are geared toward programming in fixed-format RPG. They've got both RPG/400 and ...
Created on 05 November 2018
92. 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
93. Scary RPG Developer Habits
(RPG)
... will play nonstop in theaters and on television all month long. So why not have a little fun with a look at some frightful habits that many RPG developers continue to practice? Let’s look at a trilogy ...
Created on 27 September 2018
94. Free-Format RPG IV: Third Edition
(MC Press Bookstore)
Traditional fixed-format RPG programmers everywhere are embracing the increased productivity, better readability, and easier program maintenance that comes with the free-format style of programming in ...
Created on 04 August 2018
95. 21st Century RPG: /Free, ILE, and MVC
(MC Press Bookstore)
    IBM i professionals are known for their dedication to the i. But while the platform has evolved, not all i programmers’ skills have kept pace. Perhaps you still code in fixed-format RPG. Or maybe ...
Created on 03 August 2018
96. 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
97. Practical RPG: New RPG Features
(RPG)
... forth between RPG programming and SQL programming. My last article spent a lot of time on SQL. This one will focus on RPG. Specifically, I'd like to discuss a couple of the more-beneficial new features ...
Created on 23 July 2018
98. Embedding SQL in Your IBM i RPG Code
(SQL)
Fixed-format and ILE RPG programs can benefit from the use of SQL statements to improve IBM i database access by Rafael Victória-Pereira Editor’s Note: This article is excerpted from chapter 11 of ...
Created on 23 July 2018
99. Introduction to ILE RPG Activation Groups
(RPG)
Learn how activation groups can help your ILE RPG programs run more efficiently, how to specify the type of group to use, and closing and reclaiming activation groups by David Shirey Editor’s Note: ...
Created on 23 July 2018
100. 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