Mastering AS/400

I am pleased to present to you the first ever study guide developed to adresse the objectives for the IBM Certified Specialist, AS/400 Professional System Operator certification exam. This text, along with its companion AS/400 Associate System Operator Certification Study Guide, is specifically intended to provide technologists with a principal and effective approach to prepare for industry certification in AS/400 technology. For the first time in the Web, this site, has online operations courses as well as for operations courses available on the traditional classroom. The text contains advanced curriculum concepts--including security, workflow, system backups, and problem management--supplemented by hands-on exercises. Each concept is presented in a pratical and pedagogically sound method that encourages skill building while providing student with helpful problem solving approaches to AS/400 operations management.


IBM's AS/400 is still a relatively new technology, different in many important ways from other computers — large and small — that have gone before it. But there should be no doubt by now that the AS/400 is here to stay and that the demand will continue to grow for trained programmers and operators who can use the AS/400 to its best advantage.

Driven by panic, I immediately set out to put together lab materials that would impress upon students the unique character of the AS/400 while teaching them the introductory skills they would need to go on to higher-level AS/400 courses.

Those lab materials have evolved into this textbook, which I hope will provide serious students of the AS/400 with a guidebook that opens to them the horizons of this remarkable machine. If this book succeeds, students who complete it should have a solid foundation in AS/400 library-object structure, utilities and database management capabilities, application development tools, and OS/400 Control Language.

Currently, the course that this book was designed for is a prerequisite to all AS/400 programming and database courses at Kirkwood Community College. As such, it eliminates the need to cover introductory topics such as SEU, PDM, and DDS in programming and database courses

Lesson 1 - Communicating with the System
Lesson 2 - Using CL
Lesson 3 - Objects
Lesson 4 - Handling Spooled Files
Lesson 5 - Describing a Database File
Lesson 6 - Creating and Using an Externally Described Database File
Lesson 7 - Introduction to Query/400
Lesson 8 - Using Logical Files
Lesson 9 - Additional Database Facilities
Lesson 10-Creating DFUs
Lesson 11-Using SDA
Lesson 12-Getting Started with CL Programming
Glossary