AS400 Tutorials

Entries Tagged as 'Database'

Inside the Mailbag: Query Manager

March 13th, 2013 Comments Off on Inside the Mailbag: Query Manager

Dear IT Pro, Recently I received an email from a reader… they didn’t quite see the value of using Query Manager vs. Query/400. I answered him via email but I also wanted to expand a little on my reply. In some ways I agree, Query/400 is quick and easy. Believe it or not I still […]

Tags:   · · · · ·

Leveraging Query/400 And SQL

September 17th, 2012 Comments Off on Leveraging Query/400 And SQL

I think it’s time to start talking up the benefits of SQL on the IBM i, AS/400 and iSeries. When I first started out on the system we did not have the licensed programs to make use of SQL… when I moved on to another company that had it I quickly realized what I had […]

Tags:   · · · · · ·

Not All Joins Are The Same

October 20th, 2011 Comments Off on Not All Joins Are The Same

When writing custom┬áreports you will eventually run into a situation where you want to be able to query data from two or more files, joining them together into the final report. This is where joins come in to play. Since relational databases, are well, relational if the data is similar or somehow related there should […]

Tags:   · · · · · ·