Tips

Tips

iSeries application development

• A power-handling CL program for multiple IBM i servers

  Rather than connecting your AS/400's to their own separate UPSs, find out how one UPS, one cable and a CL program can manage all your power-handling needs.  Continue Reading

• 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

• Tracking data changes on IBM i with triggers

  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

• 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

• Implementing a browser interface in COBOL: Displaying database fields

  Learn how to display a file list from your AS/400 database on a Web page using COBOL, CL and HTML. Get code samples and see how you can use DSPOBJD to create a FILELIST that will display on the Web page.  Continue Reading

• Taking advantage of CL advancements, starting with V5R3

  Using the new CL programming tools released in V5R3 on the IBM System i has advantages: New looping methods, subroutines, and multiple file declarations. See examples of old versus new programs that ease and shorten programming commands.  Continue Reading

• Implementing a browser interface in COBOL: Getting started

  Learn how to get started on developing a Web interface from the AS/400 in COBOL starting with a logon page. Includes code samples for CGI APIs and library and DDS instructions.  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

• Checking in on your IBM i authorization lists

  Have you ever created an object on the AS/400 without making sure the necessary authorization list is attached? By using some common commands, you can secure your IBM i, and audit objects and fix mistakes. The necessary commands include DSPAUTLOBJ ...  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

• Database performance comparisons on IBM i

  Testing performance of RLA in the IBM Java Toolbox against JDBC and native I/O for the AS/400 revealed that RPG on System i is the most efficient language, and DB2 is taken for granted. Joe Pluta built some benchmarks to compare different aspects of...  Continue Reading

• Database drivers on the i: MySQL vs. IBM Toolbox

  Which reads data from i faster: MySQL or IBM Toolbox drivers? Joe Pluta put the drivers to the test in both an AS/400 and a Windows environment. The conclusion: MySQL over its own database performs roughly as well as IBM's Java Toolbox over DB2 data...  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

• An automated CL method of moving a query from AS/400 to Excel

  If a daily task of your AS/400 is to print a report from a query a CL program can be written to automate the task and make it easy to open the results in Excel. This CL program copies an existing query to QTEMP and runs the query. Then it converts ...  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