iSeries Navigator is now one of the most powerful tools available to iSeries Programmers. With a mastery of iSeries Navigator, you can shorten your learning curve for acquiring new skills, like working with the Integrated File System and SQL. iSeries Navigator for Programmers was developed by Paul Touhy, specifically for iSeries programmers. The training is self-paced and comes with a CD containing all code used. This training is also a useful desktop reference you'll turn to time and again. Most importantly, you’ll learn to do things you simply can’t do on Green Screens. HERE IS WHAT YOU WILL LEARN: ·How to get a graphical view of your database with Database Navigator ·How to manage Triggers ·How to manage and work with SQL constraints ·How to perform the GUI equivalent of WRKSPLF, DSPMSG, WRKUSRJOB, etc. When to use the GUI interface and when green screen is still best ·How to access the IFS from Windows ·How to manage the IFS with iSeries Navigator ·How to get the equivalent of Network Neighborhood on green screen ·How to use iSeries Navigator to manage the database without becoming an expert in SQL ·When to use SQL and when to use DDS ·How to use GUI interfaces to create tables, indexes, and views ·How to create User Defined Functions, the most powerful features available through the databaseEasy ways to get started with SQL

iSeries Navigator for Programmers

Computers & Technology

Tuohy, Paul

Operating Systems

Rochester Initiative

There are hundreds of thousands of AS/400s around the world that are running legacy applications - applications that were developed early in the life of the AS/400 or for the System/36 or System/38 or even the System/3! Many of these applications are the backbone of your business. They manage your payables and receivables, run your payroll, balance your accounts, and provide the tools that you use to make important business decisions. Should they be updated to more current technology to take advantage of the powerful enhancements IBM has made to the AS/400, OS/400, and RPG? Many would say "No" without thinking through the implications of that decision. Putting your company's IT resources in a condition of stasis while technology moves on may be a costly business mistake. It is not only possible, but also profitable, to derive some of the benefits of new technology from within a legacy application. IBM's recent enhancements provide a means of immediately increasing application reliability and programmer productivity with relatively little effort, while building a firm basis for the future of your business. While the technology means new concepts to be learned and new programming skills to be acquired, very few of these new enhancements are so radically different that they fall outside the grasp of the average RPG programmer. This book is a tutorial aimed at showing programmers how to convert and re-engineer their applications by taking them through a re-engineering of a sample application - step by step. Author Paul Tuohy covers conversion of RPG IV programs as well as re-engineering them to take full advantage of RPG IV and ILE. He also covers triggers, referential integrity, and APIs so that your applications can take advantage of all the new technology that is available today. This book will be a valuable aid as you evaluate your legacy applications and then move into re-engineering. Upon completion of this book, you will be able to: Understand the re-engineering process, assess the business reasons for re-engineering, evaluate legacy applications' need for re-engineering, enhance and modularize your applications and programs with RPG IV and ILE, know the difference between conversion and re-egineering with RPG IV, understand the basics and more advanced features of RPG IV, convert to RPG IV using IBM's or third party software, incorporate built-in functions to enhance your applications, understand and implement powerful subprocedures in your programs, enhance your applications design with prototyping, use ILE effectively in the re-engineering process, implement service programs to strengthen your applications, incorporate triggers and referential integrity for standardization and security of your database, and utilize the new, powerful APIs to broaden the scope of your application.

Re-engineering RPG Legacy Applications

Computer Science

Mc Press

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 Gantner 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

The Programmer's Guide to iSeries Navigator

Programming

See the best price to sell, buy, or rent books by Tuohy, Paul. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Tuohy, Paul