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

  MC Press Online eBookStore  

Programmer's Guide to iSeries Navigator
preview of book Programmer's Guide to iSeries Navigator
text of book Programmer's Guide to iSeries Navigator

Programmer's Guide to iSeries Navigator

Publisher: MC Press Online
Publication Date: February 2006
Subject: Computer: Programming -- RPG
Category: Programming
Number of Pages: 377

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: 978-1-58347-047-3  
 Reg.: $
74.99 per N pages
 You Save: 
$36.75 (49%)
 Online  Open CopyPrint    
all time
Printed Edition   see MC Press Online    
About this title
With a Foreword by Susan Gantner.

iSeries Navigator is a favorite tool of operators and administrators--who use it with great success--but many programmers have missed the great programming tools it provides! This book introduces you to iSeries Navigator along with all the powerful tools and interfaces that will expand your programming horizons. As iSeries applications continue to move toward a graphical user interface (GUI), so does the development environment. Programs such as CODE and WDSC may fill the need for the programming environment, but iSeries Navigator fills the programmer's need for general system access as well as database management and development.

Starting with an introduction to the basics of iSeries Navigator--including how to perform standard day-to-day commands in Navigator as opposed to green screen--the book goes on to explain the advantages of Navigator over green-screen operations.

For the programmer, it is in the GUI interface to DDL in Navigator that programmers will realize the most benefit. And, as DDS for database is replaced by SQL's DDL, the importance of knowing iSeries Navigator will grow. Navigator also provides GUI equivalents of standard green-screen commands such as WRKSPLF, WRKSBMJOB, and DSPJOB, as well as graphical access to the Integrated File System (IFS).

To maximize your efficiencies as a programmer, you need to learn the intricacies of this interface. Join Paul Tuohy as he shows you the ins and outs of iSeries Navigator in a helpful, comprehensive, and entertaining way.

With The Programmer's Guide to iSeries Navigator, you will:
  • Learn iSeries Navigator from a programmer's point of view
  • Discover database features that are uniquely available with DDL
  • Get a true GUI interface to the Database Navigator that far exceeds any green screen
  • Use the Integrated File System (IFS) to access PCs from the iSeries
  • Access the IFS to share directories, store program sources, and more
  • Discover Navigator tools that simplify SQL coding
  • Simplify the task of creating SQL tables in place of DDS-created physical files
  • Improve the performance of your SQL statements with the Visual Explain tool
  • Master the database feature of Navigator to create and maintain collections, tables, views, indexes, constraints, and functions
About author
Paul Tuohy
Paul Tuohy has been working in application development on IBM midrange systems for more than 25 years. He has worked as IT manager for Kodak Ireland and technical director for Precision. He is currently CEO of ComCon, an IBM i consulting company. Paul has also worked for many years as an instructor in the IBM Education Center in Dublin, Ireland, specializing in courses in programming and application development. Mr. Tuohy has updated thousands of RPG programs to incorporate the best that the new versions of RPG and IBM i have to offer. In this book, he combines this knowledge with his teaching ability to show RPG programmers how to update and enhance their legacy applications.


Green Screen or GUI
For the Programmer
And the Rest
Where Do You Get It?
But Admin Won't Let Me Use It
The Contents

Chapter 1: Getting Started
Navigating Navigator
Using Navigator
That Was Easy!

Chapter 2: Basic Functions
Printer Output
Run a Command
Work Management Jobs
Job Queues
Output Queues
System Status
Bases Covered

Chapter 3: File Systems
The Integrated File System
Start With What You Know
The Root File System
The Other File Systems
Accessing the IFS from Windows
Accessing the IFS from QSYS
File Systems Expanded

Chapter 4: Simple Database Features
Basics Done

Chapter 5: Advanced Database Features
SQL Scripts
Run SQL Scripts
Field Reference Files
Distinct Types
Do You Use DDL or DDS?

Chapter 6: Referential Integrity and Triggers
Referential Integrity
Trapping Errors

Chapter 7: User-Defined Functions and Stored Procedures
User-Defined Functions
Stored Procedures
In Perspective

Chapter 8: Get the Picture
Database Relations
Database Navigator
Got the Picture?

Chapter 9: Pros and Cons
The Pros
The Cons
Which to Choose

Chapter 10: Management Central
Endpoint Systems and System Groups
Central Out

Chapter 11: Other Items of Interest

Chapter 12: Summary

Appendix A: Install and Configure iSeries Navigator
Installing iSeries Navigator
Get the Service Pack
Configuring a Connection
Up and Running

Appendix B: Make the Database

Related titles
Mastering IBM iMastering IBM i
Programming in RPG IVProgramming in RPG IV
SQL Built-In Functions and Stored ProceduresSQL Built-In Functions and Stored Procedures
SQL for eServer i5 and iSeriesSQL for eServer i5 and iSeries
  Special Offer Code  
Enter your Special Offer Code here:
  Search for  

  Our Products  
Browse all »»
From Idea to Print, Chapter 05: Developing the First Draft
Complete CL
DB2 11: The Database for Big Data & Analytics

If download option is selected, Adobe Acrobat 5.0 or lateris requiredto read our e-books*

*Windows PC, Mac OS9/OSX, and Linux