AS400 Tutorials

Entries from November 12th, 2012

Single Level Storage

November 12th, 2012 Comments Off

Dear IT Pro, One of the things any administrator on the IBM i takes for granted is the DB2 database just works and is more or less self optimizing. Have you ever wondered how or why that is? Go check out this article: http://db2fori.blogspot.com/2012/11/one-of-crown-jewels-single-level-storage.html The DB2 for i blog is on my shortlist for good […]

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

Help Me Brainstorm My Next Product

November 2nd, 2012 10 Comments

I have a couple of thoughts rolling around for my next product. But first I want to hear from YOU my blog reader and customer… so I am going to conduct a little informal poll. What is it you want or need to know? AS/400 and IBM i programming? Report writing? Administration? Something else? I […]

Tags: