AS400 Tutorials

Entries Tagged as 'SQL'

How to Quickly Master the IBM i

September 10th, 2014 Comments Off on How to Quickly Master the IBM i

Sometimes I get asked, out of all my offerings: what’s what … and how do the pieces fit together. So let’s break it down. If you are new to the AS/400 & IBM i world… maybe you’re an new system administrator, operator, programmer, manager, what have you. And you need to get up to speed […]

Tags:   · · · ·

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:   · · · · ·

Making Use Of SQL Views

November 9th, 2012 1 Comment

Dear IT Pro, Views are a really fantastic feature of SQL. On the IBM i a view is implemented as a logical file that does not have a key… this means the system does not have to maintain an access path or incur overhead with a view. If you can put together a simple select […]

Tags:   ·