Problem solve
Get help with specific problems with your technologies, process and projects.
RPG iSeries programming
Enhancing RPG with external SQL stored procedures
Registering an external SQL stored procedure and leveraging RPG with your creation allows for increased flexibility in dealing with numerous types of data. Continue Reading
Introduction to SQLRPGLE on IBM i: Making a report
Using RPG ILE with embedded SQL can be a fast way to make database reports on the IBM i. Joe Pluta shares the code of his first SQLRPGLE program. Continue Reading
Making the most of RPG data handling on IBM i
By virtue of being bult-in to the AS/400, RPG has speed for some operations that SQL cannot touch. Learn how RPG works with indexing to retrieve data from your IBM i. Continue Reading
-
Allow access to data from a stored procedure result set using COBOL or RPG
For COBOL and RPG programs to process the data after the stored procedure call completes, you need to direct the SQL stored procedure to place the result set in a global temporary table. COBOL and RPG cannot access embedded SQL as of V6R1. Continue Reading
EGL Rich UI on IBM i: Do you Dojo?
Taking advantage of the Rich UI features of EGL architecture on the AS/400 can save you time and complexity. Rich internet applications can be difficult to write, even with Java and Webspher. EGL eliminates the need for programmers to learn ... Continue Reading
Documenting nested program structures on the AS/400
Documenting nested program structures on AS/400 is a complex task and is sometimes overlooked or not updated. The XPGMSTR command automates documentation in a structured and reliable way, eliminating the human-error (or lazyness) involved in the ...Continue Reading
Eight steps for creating program documentation using AS/400 utilities
To make a programmer's work easy and efficient, program documentation should be completed up front. This tip presents eight strategic steps for AS/400 documentation, with helpful screenshots.Continue Reading
Chain operation error after converting RPG3 to ILE RPG (RPGIV)
RPGIV will 'think of' incoming integer fields as binary, and then will redefine them in the program structures as PACKED. So, when you chain a record, the incoming data has to be converted from integer (which RPGIV thinks is Binary) to packed. This ...Continue Reading
Dynamic SQL statement in an RPG program
DB2/400 and DB2 UDB expert Kent Milligan discusses how to substring a character field on an SQL join statement.Continue Reading
RPG dynamic value calculation versus hard-coded values
iSeries RPG expert Kevin Ketlzer illustrates dynamic value calculation in this example on programming on the iSeries.Continue Reading
-
System i date conversions in RPG
Date conversion in RPG is something that we do without too much hassle. Years ago, we'd use wacky calculations, which are now deemed harmful to proper processing. The old multiply by 100.0001 is a bad way to go. System i programming expert Andrew ...Continue Reading
Embracing RPG IV
RPG IV is much more then just an extension of RPG III. Enhancements in the language provide new ways of doing things, which, in turn, necessitate a change in day-to-day coding practices.Continue Reading
Java for RPG Programmers, Third Edition -- Chapter 10
This chapter, "Exceptions," will help you to understand the various roles of Java in today's applications, learn the core Java language, discover how to use the Java Development Kit (JDK) and much more.Continue Reading
RPG SELEC statements: Improve the performance
According to systems management expert Ron Turrull, the performance of your RPG programs may be suffering if you use the SELEC statement. Ron says that the SELEC op-code is a great, recently added feature in RPG used to create multi-conditioned, ...Continue Reading
Free form RPG: Are you /FREE?
System i (AS/400) programming expert Paul Tuohy attended a recent Common User Discussion Social (CUDS) recently where the conversation centred on free form RPG. Paul shares some of the points discussed, highlighting the highs and lows of using free...Continue Reading