Problem solve

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