AS/400 Programming Tips, Tricks, & Techniques:

AS/400


May 3, 2013  7:12 PM

How to Create a UIM Menu from Scratch



Posted by: Eric Witham
AS/400, IBM i

Happy Friday Everyone! (Originally I meant last Friday, when I started writing this) One of the projects on my Side List is to convert the User Menus on our system from either a DSPF type or a MNUDDS/MNUCMD type member to a UIM Menu. I must say, ever since I started modifying UIM Menus...

April 17, 2013  6:54 PM

Resolving a Common Issue: CPD90B1 – Distribution Limit of 9999 Reached



Posted by: Eric Witham
AS/400, IBM i

Greetings Readers. This being my first post, please allow me to introduce myself. My name is Eric and I am currently a Administrator/Senior Programmer for H&M International Transportation, Inc. in Central NJ. Although I have only been working here for 3 months now, I have been in the AS/400...


November 6, 2012  3:59 PM

All About the SQL Query Engine



Posted by: John Andersen
AS/400, IBM i

In my past posts I mentioned the SQL Query Engine that evaluates, plans and drives your SQL queries on the IBM i platform. For speed and performance you really should understand why using the SQE is where its at. Here is a good article that dives more deeply into the SQE versus the CQE engines...


November 5, 2012  9:13 PM

Getting Started With IBM i SQL



Posted by: John Andersen
AS/400, IBM i

In my previous article I talked about the virtues of moving from Query/400 to DB2 Query Manager, with the major advantage being you can use SQL and all of the features that come with it... But how do you...


November 2, 2012  5:55 PM

Time To Dump Query/400



Posted by: John Andersen
AS/400, IBM i

I admit opening up Query/400 (IBM Query for i) on the rare occasion to crank out a straight forward report. I think its more for nostalgic reasons because Query was the first reporting tool I learned on the AS/400 so many years ago. But my Query/400 use is becoming less and less and instead I...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: