AS400 Tutorials

Entries from November 12th, 2012

Single Level Storage

November 12th, 2012 Comments Off on Single Level Storage

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: