Home > IT Blogs > AS/400 Programming Tips, Tricks, & Techniques/

AS/400 Programming Tips, Tricks, & Techniques:

November, 2012

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...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

November 6, 2012  12:08 AM

The IBM i Sucks



Posted by: John Andersen
Uncategorized

Here is an article for you to check out: http://enterprisefeatures.com/2012/10/the-ibm-i-sucks-iseries-as400/ Of course the IBM i doesn't really suck, click on the article and find out why. -John...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

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...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend