 |
MC Press Online eBookStore |
|
Mastering IBM i |
| Author: Jim Buck | | Publisher: MC Press Online | | Publication Date: April 2011 | | Subject: Computer: Operating Systems |
|
|
|
|
|
| | 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.
|
| Contents |
Introduction
Chapter 1: Communicating with the System
The System
IBM i Objects
Subsystems
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
Databases
File Systems
In Summary
Key Terms
Review Questions
Lab 10
Chapter 11: Using Remote System Explorer
History
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
Compiling
Debugging Overview
Debugging a Program
Running a Program
In Summary
Key Terms
Review Questions
Lab 11
Chapter 12: Using Screen Designer and Report Designer
History
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
Print
Messages
Jobs
Other
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
Summary
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
Index |
| Related titles |
|
|
| |
|
|
|
|
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 |
| |
|
|
