|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
|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
Chapter 1: Getting Started
That Was Easy!
Chapter 2: Basic Functions
Run a Command
Work Management Jobs
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
Chapter 5: Advanced Database Features
Run SQL Scripts
Field Reference Files
Do You Use DDL or DDS?
Chapter 6: Referential Integrity and Triggers
Chapter 7: User-Defined Functions and Stored Procedures
Chapter 8: Get the Picture
Got the Picture?
Chapter 9: Pros and Cons
Which to Choose
Chapter 10: Management Central
Endpoint Systems and System Groups
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