Programmer's Guide to iSeries Navigator
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 that is 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...
Search in google:
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 that is 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 Navigators that they 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 a foreword by Susan GantnerWith The Programmer’s Guide to iSeries Navigator you will: • Learn iSeries Navigatorfrom 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
Contents: Introduction Chapter 1: Getting Started Chapter 2: Basic Functions Chapter 3: File Systems Chapter 4: Simple Database Features Chapter 5: Advanced Database Features Chapter 6: Referential Integrity and Triggers Chapter 7: User-Defined Functions and Stored Procedures Chapter 8: Get the Picture Chapter 9: Pros and Cons Chapter 10: Management Central Chapter 11: Other Items of Interest Chapter 12: Summary Appendix A: Install and Configure iSeries Navigator Appendix B: Make the Database Index
