The AS/400 Programmer's Handbook, Volume II

As in his original, author Mark McCall begins each section of
Volume II with a thorough discussion of each topic, including how it fits
into everyday application use. He then shows and explains several examples
from real-life applications--code that's ready to run in your applications.
He tells you what the example does and how it works, all in a
programmer-to-programmer style that makes you feel as if you have a mentor
sitting right beside you. Designed to work as a functional programming
tool, each example is presented as a self-contained instrument, allowing
you to get in, get the information you need, and get on with business.

When you have completed this book, you will know:

• 5 modular coding technique
  examples, including /Copy compiler directives, subroutines, dynamic
  subprograms, subprocedures, and service programs
• 24 examples of RPG's
  most useful built-in functions
• 7 exit program examples, including user
  profile monitoring, data transfer security, and job notification
• 8 system
  API examples, including command execution and processing, retrieval APIs,
  list APIs, user space APIs, and ILE CEE APIs
• 5 database constraint
  examples, including check constraints, unique and primary key constraints,
  and referential integrity constraints
• 3 database trigger program examples
• 19 SQL examples, including logical views, selects, joins, summaries,
  and embedded SQL

Contents

Introduction

RPG Programming examples

• Modular coding techniques
  
• Built-in functions
  
• Exit programs
  
• Application programming interfaces
  

• Data constraints
  
• Database triggers
  
• Using SQL
  

Index