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 […]
Entries Tagged as 'Database'
March 13th, 2013 Comments Off
September 17th, 2012 Comments Off
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 […]
October 20th, 2011 Comments Off
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 […]