Email Alerts
-
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. Tip
-
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. Tip
-
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. Tip
-
Migrating from RPG to EGL on IBM i
The IBM Rational Migration Extension for IBM i (RMEi) migrates existing RPG programs to EGL. Learn when migrating from RPG to EGL may have advantages to your business, and how EGL integrates procedural and object-oriented langauges into the same spac... Tip
-
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. Ask the Expert
-
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 JavaScrip... Tip
-
Programming for the Web on the IBM i, what is possible
The AS/400 has many options for Web enablement, despite the green-screen image. Learn what Web languages are available and get resources to use as you embark on your Web journey, such as RPG, Net Dev, Java, PHP, Tomcat and others. Tip
-
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 usua... Tip
-
How to: Sort arrays using RPGIV
RPGIV allows you to sort arrays by creating records that contain elements that are in turn treated as a separate array. This allows you to sort the elements of the record in different ways depending on your needs. In this example, you can sort by SUM... News
-
How to use an embedded SQL statement and display the result in a subfile
Are you looking for a way to load a file based on several search criteria and then display the file in a subfile? John Blenkinsop provides the needed RPG code to get it done on the AS/400. News