AS400 Tutorials

One of the nice things about an AS/400, iSeries or System i machine is the database is tightly integrated into the operating system. The reality is that many 400 administrators aren’t really experts at DB2 because you dont need to be to make use of the database.

Understanding how to enter DDS specifications into a source file and compile them into physical and logical files is really as far as you need to go for 90% of the tasks involved in running a 400. Yes, nowadays you see alot about using DDL (essentially SQL) to create tables but I am still a fan of DDS and do create views using SQL statements when it makes sense to do so.

Recently I have been working on a tier three ERP system from one of those conglomerated software consolidation companies. Chances are you have heard of them if you have been around ERP systems in the last few years. 

The one thing I really hate about this system (which uses a mainstream database on the backend running on a Win32 platform) is how clunky the report writing process is. It’s not elegent, and it’s not tightly integrated into the system itself. In short I think it sucks.

This is precisely an area where the AS/400, iSeries and System i shines. You have so many native tools and applications to work with the underlying database. You have tools like Query/400, Query Manager, direct SQL and so much more that simply plugs right in and goes. You don’t have to learn a bunch of complicated syntax to use programs like Query/400 either because its entirely menu driven.

Many people these days are frowning on “green-screen” based programs.

My take is always to use the right tool for the job and sometimes that is a query report or interactive lookup screen using runqry or query definition. The command line and perhaps a small CL program allows this to be transparent to the user, so who cares if the resulting data is displayed on an old fashioned green-screen.

So to get started writing reports check out the following short list of commands/programs:

WRKQRY
STRQMQRY
RUNQRY
Operations Navigator (allows you to execute and thoroughly examine SQL statements)

One area that used to be lacking on the AS400 was report manipulation or report mining tools. People used to print out thousands of pages of reports (and many still do) just to pull out a couple pages with the pertinent details and then throw the rest away.

But nowadays there are so many third party tools that will take your spool files and convert them into plain text for your PCs. Even Operations Navigator has had this capability for many years. It even allows you to search through files and outqs. End users can even do this with a little bit of training on Operations Navigator, it’s not that difficult and they will love you for it.

There really aren’t many excuses for getting the most out of your systems today. We aren’t living in the stone age where data extraction and reporting writing for the AS/400 is complicated thanks to the myraid of tools that have been available for many years now.

Tags:   AS400 · AS400 Tutorial · Database · DB2 · iSeries · OS400No Comments