iSeries ILE programming Get Started
Bring yourself up to speed with our introductory content
Triggers can be implemented on the AS/400 using a high-level language or SQL and can be used to enforce business rules or validating input data. Learn how to use DB2 triggers as a means of auditing data inserts, deletes or changes. Continue Reading
Evaluate iSeries ILE programming Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
Ron Turull provides a "helper" program to let you save and restore the screen using two DSM APIs from a non-ILE program. Continue Reading
This time we turn our attention to a couple of DSM APIs that can be used to take a "snapshot" of the screen, save it and restore it later using the saved data. Continue Reading
Problem Solve iSeries ILE programming Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
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
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
In AS/400, if you need to find database fields that contain a specific value, in ILE RBG the field to use is D1FIND. The trick is that you have to add code to turn all search terms into uppercase, or the program won't recognize the search term if ... Continue Reading