A comprehensive resource that can be used by RPG programmers as they advance from basic subfile usage to more advanced programming, this manual offers concepts, explanations, and practical examples that reflect current trends. With downloadable templates that include both the DDS and RPG IV code, this resource provides the techniques and styles-from basic single-page displays to powerful methods such as recursion, data queues, and embedded SQL-that enable RPG programmers to become subfile masters. With updated code that shows modern methods, such as ILE strategies and free-format RPG, this reference offers a bounty of practical examples and advanced techniques.

Focusing strictly on teaching free-format RPG programming methods, this book will help programmers wishing to upgrade their skills This how-to guide offers a concise and thorough introduction to the increased productivity, better readability, and easier program maintenance that comes with the free-format style of programming in RPG IV. Although free-format information is available in IBM manuals, it is not separated from everything else, requiring hours of tedious research to track down the information needed. This book provides everything you need to know to write RPG IV in the free-format style. Author Jim Martin not only teaches rules and syntax, but also explains how this modern style of coding has the potential to improve overall programmer productivity--from initial development through maintenance. He methodically covers the many style issues, such as named indicators and built-in functions, and addresses topics including input and output, program flow, data manipulation, math operations, prototyping, and APIs. This third edition is updated to V7.1 of the IBM i operating system on IBM Power machines. An added chapter explains the new free-format H, F, D, and P specifications introduced by IBM in Technology Refresh 7, and programming examples throughout the book are updated to reflect the new specifications.

This book begins with easy-to-understand explanations of subfile concepts then goes on to offer a bounty of practical examples, advanced techniques, and other cool stuff never before seen in subfile books. It is a comprehensive resource you will use over and over as you advance from basic subfile usage to gurulike mastery of subfile programming. This book provides you with the concepts, styles, and advanced techniques using RPG IV and ILE that will enable you to become a subfile master in your own right.

"Level: novice to advanced"--Back cover.

This guide teaches programmers who have been left behind in the IBM i's evolution to code more productively and modernize their business applications. Shirey uses a casual, humorous teaching style to explain the concepts, along with plenty of code examples. Readers will gain confidence in areas that may be new to them and use the provided examples to practice what they've learned. The manual is structured so that whether they are using the latest IBM i technology or an older version, readers will learn methods to improve coding and applications, as well as become comfortable with writing programs using ILE RPG, free-format RPG, and Model-View-Controller (MVC).

This how-to guide offers a concise and thorough introduction to the increased productivity, better readability, and easier program maintenance that comes with the free-format style of programming in RPG IV. Although free-format information is available in IBM manuals, it is not separated from everything else, thereby requiring hours of tedious research to track down the information needed. This book provides everything one needs to know to write RPG IV in the free-format style, and author Jim Martin not only teaches rules and syntax but also explains how this new style of coding has the potential to improve overall programmer productivity--from initial development through maintenance. He methodically covers the many style issues, such as named indicators and built-in functions, and addresses topics including input and output, program flow, data manipulation, math operations, prototyping, and APIs. This second edition is updated to V7.1 of the IBM i operating system on IBM Power machines, including a chapter on the Technology Refresh 7 (TR7) enhancements. Updated throughout, the book explains the latest techniques for source program entry (LPEX editor in RDp), the new way to code Embedded SQL in free-format, and other items that have occurred in the years since the first edition.

This book is designed for professional application developers and college-level students who want to become developers. It features thorough and updated coverage of database design and SQL for DB2. Topics covered include database concepts, SQL inquiries, web applications, and database security. The material is reinforced by numerous illustrations, examples, and exercises.

Here is the ultimate guide to writing RPG IV programs with functions in the free-format style. Let RPG expert and best-selling author Jim Martin show you the way. Want to generate a random number, manipulate a character string, or determine the number of elements in a data structure? There's a function for that. Jim will even show you how to write your own custom built-in functions (BIFs). In this book, you'll discover the role of functions in free-format RPG IV. Jim explains the details of built-in functions (BIFs) and explores the use of C language functions, do-it-yourself functions (subprocedures), and prototyping and procedure interfaces for function connectivity of RPG IV main procedures with subprocedures and other modules. Because functions rely heavily on ILE, the book examines those ILE concepts that connect the parts of a multi-functional program, such as binding, import/export of data, service programs, and binding directories. In addition, you'll find how to prototype IBM's APIs.