MC Press Online
Welcome to the MC Press Online!
Need help with our eBooks?
Click here, to go to our main store

  MC Press Online eBookStore  

Mastering IBM i
preview of book Mastering IBM i
text of book Mastering IBM i

Mastering IBM i

Publisher: MC Press Online
Publication Date: April 2011
Subject: Computer: Operating Systems
Number of Pages: 953

Free Preview    Email to Friend   Add to wish list
 Available as: (for format`s description click on its name)
Individual E-Version (PDF) Individual E-Version (PDF) ISBN: 9781583473566  
 Reg.: $
85.95 per N pages
 You Save: 
$27.50 (32%)
 Online  Open CopyPrint    
all time
Printed Edition   see MC Press Online    
About this title
The IBM i operating system running on IBM Power Systems is a platform in transition. Today's IBM i programmers must have a solid understanding of the operating system's traditional concepts and tools, but they also need to know how to take advantage of IBM's latest tools and methods. With Mastering IBM i, both new and experienced programmers finally have a complete and up-to-date resource for the tools and concepts needed to work with today's IBM i.

For new IBM i programmers, Mastering IBM i introduces the fundamentals of working with the system, explaining both traditional tools and concepts as well as IBM's latest tools in depth. For veteran programmers, the book provides the resources to gain the expertise required to update current skills. The book serves as a handbook for many of IBM's newest tools, providing information that will be useful regardless of your level of IBM i expertise.

Mastering IBM i is equally well suited to a classroom setting or individual study. Like its highly regarded predecessor, Mastering the AS/400, the book takes a hands-on, experience-based approach to learning. Each chapter includes key terms and review questions plus step-by-step chapter labs that reinforce understanding through doing. New chapters cover the latest system concepts and IBM i tools—Rational Developer for Power (RDP), Remote System Explorer, RDP's Screen Designer and Report Designer, IBM i Access for Windows, IBM i Access for Web, and IBM DB2 Web Query for i.

With Mastering IBM i, you will:
  • Learn the essential concepts and tools required to work with IBM i systems
  • Understand traditional methods of working with the system, as well as newer methods such as SQL
  • Update your skill set by learning how to use IBM's latest graphical tools and methods
  • Gain a solid foundation for more advanced programming studies, such as CL and RPG
About author
Jim Buck
Jim Buck's career in IT spans more than 25 years, primarily in the manufacturing and healthcare industries. He is a programmer/analyst instructor at Gateway Technical College in Kenosha, Wisconsin; eight-year president of the Wisconsin Midrange Computer Professional Association (WMCPA); co-author of three IBM i textbooks; and the recipient of the 2007 IBM System i Innovation – Education Excellence Award. Jim has been instrumental in creating an advisory board for Gateway's IBM i curriculum, developing classes and seminars in IBM's programming software, and opening networking opportunities for students.


Chapter 1: Communicating with the System
The System
IBM i Objects
Types of Jobs
Control Language (CL)
System Values
Licensed Programs
User Profile
User Interface
Menu Screens
Prompt Entry/Command Prompt Screens
Using Help
List or Work-With Screens
In Summary
Key Terms
Review Questions
Lab 1

Chapter 2: Using CL
CL Commands
Control Language Syntax
Menus of Commands
The GO Command
Library Lists
In Summary
Key Terms
Review Questions
Lab 2

Chapter 3: Objects
The IBM i Object-Based Architecture
Types of IBM i Objects
Requesting an Object
Qualified Names
Library-List Commands
Locating an Object
Storing Objects
Simplified Batch Work Management
In Summary
Key Terms
Review Questions
Lab 3

Chapter 4: Handling Spooled Files
Printer Files
Printer Writer
Changing Writers
Changing Spooled Files
Clear Output Queue
Assistance Levels
In Summary
Key Terms
Review Questions
Lab 4

Chapter 5: Describing a Database File
File Varieties
Program-Described Files
Externally Described Files
In Summary
Key Terms
Review Questions
Lab 5

Chapter 6: Creating and Using an Externally Described Database File
More About SEU
Compiling the File Description
Displaying an Object's Description
Data File Utility
In Summary
Key Terms
Review Questions
Lab 6

Chapter 7: Introduction to Query
What Query for i5/OS Does
Starting Query for i5/OS
Working with Queries
Defining a Query
Refining Your Query
A Conceptual Foundation for Joining Files
Creating a Join Query
Specifying the Join Relationship
In Summary
Key Terms
Review Questions
Lab 7

Chapter 8: Using Logical Files
Physical Files and Access Paths
Logical Files
Creating a Logical File
Creating Join Logical Files
Projection, Selection, and Access Path with Join Logical Files
Using Query for i5/OS with a Join Logical File
Multiple-Format Logical Files
In Summary
Key Terms
Review Questions
Lab 8

Chapter 9: Additional Database Facilities
Creating a File (Review)
Changing the Source DDS
Recompiling Programs and Queries That Use a Changed Physical File
Dealing with Based-On Logical Files
Using CHGPF to Modify a Physical File
Database File-Level Security
In Summary
Key Terms
Review Questions
Lab 9
Additional Lab Exercise

Chapter 10: Using IBM i Navigator
Introduction to IBM i Access
Accessing Help
Creating a Connection to the System
Basic Operations
Work Management
File Systems
In Summary
Key Terms
Review Questions
Lab 10

Chapter 11: Using Remote System Explorer
Getting Started
  Creating a Connection
  Library List: Add, Change, Remove Libraries
  Creating a Source Physical File
  Copying a Member
  Opening and Editing a Member
  Editing and Saving
  Debugging Overview
  Debugging a Program
  Running a Program
In Summary
Key Terms
Review Questions
Lab 11

Chapter 12: Using Screen Designer and Report Designer
Getting Started
  Modifying a Print File
  Adding Records to a Print File
  Adding Fields and Modifying Properties
Creating a Display Screen
  Create the Display Screen Source Member
  Add a Record
  Add Keywords to a File or Record
  Add Fields to the Record
  Add Database Fields to a Record
  Compile the Display
In Summary
Key Terms
Review Questions
Lab 12

Chapter 13: Introduction to SQL
A Short History of SQL
Introduction to SQL Terms
Introduction to SQL
Interfaces Used to Enter SQL Commands
Starting the Run SQL Scripts Interface
SQL Syntax
File Maintenance Using SQL
Using SQL Assist/Prompt
In Summary
Key Terms
Review Questions
Lab 13

Chapter 14: Using IBM i Access for Web
Introduction to IBM i Access for Web
  5250 User Interface
  Database Function
In Summary
Key Terms
Review Questions
Lab 14

Chapter 15: Introduction to DB2 Web Query for i
DB2 Web Query for i
Query for i5/OS Limitations
DB2 Web Query Features
Getting Started with DB2 Web Query
DB2 Web Query Help
Introducing InfoAssist
Creating the Profit Margin Inventory Report
Creating a Profit Margin Chart
Creating a Compound Document
Key Terms
Review Questions
Lab 15

Chapter 16: Getting Started with CL Programming
CL Review
CL Program Uses
Advantages of CL Programs
Creating CL Programs
Using RDP to Enter CL Source
CL Program Structure
Designing the Start-Up Program
Entering the Program
  Declaring a File
  Declaring Variables
  Changing the Value of a Variable
  Control Structures
  Iteration Structures
  File I/O in CL Programs
  Sending Messages
  Using Concatenation
Finishing the Start-Up Program
Creating a CL Program
In Summary
Key Terms
Review Questions
Lab 16
Lab 16 Source Listings

Related titles
Complete CLComplete CL
Control Language Programming for IBM iControl Language Programming for IBM i
Database Design and SQL for DB2Database Design and SQL for DB2
Free-Format RPG IV, 2nd EditionFree-Format RPG IV, 2nd Edition
i5/OS and Microsoft Office Integration Handbooki5/OS and Microsoft Office Integration Handbook
IBM i5/iSeries PrimerIBM i5/iSeries Primer
Programming in ILE RPGProgramming in ILE RPG
Remote System Explorer, TheRemote System Explorer, The
SQL Built-In Functions and Stored ProceduresSQL Built-In Functions and Stored Procedures
SQL for eServer i5 and iSeriesSQL for eServer i5 and iSeries
Programmer's Guide to iSeries NavigatorProgrammer's Guide to iSeries Navigator
Understanding AS/400 System OperationsUnderstanding AS/400 System Operations
WDSC: Step by StepWDSC: Step by Step
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
Java for RPG Programmers
DB2 10 for z/OS Database Administration (Exam 612), Chapter 09: Data Sharing
Fundamentals of Technology Project Management

If download option is selected, Adobe Acrobat 5.0 or later is required to read our e-books*

Windows PC, Mac OS9/OSX, and Linux