Database Design and Programming for DB2/400

Conte, senior technical editor for NEWS/400 magazine, provides a thorough introduction to the design and implementation of application databases on IBM's AS/400. The material is organized into four parts: DDS, database design, SQL, and advanced DB2/400 features, and covers everything from coding DDS and entering CL commands to advanced DB2/400 features such as commitment control, the Open Query File command, database constraints, triggers, and distributed data base access. Each chapter includes numerous examples and exercises. Annotation c. by Book News, Inc., Portland, Or.

Paul Conte is president of Picante Software, Inc., a software development company in Eugene, Oregon. He’s also a senior technical editor for NEWS/400 magazine. Paul is a widely published expert on database systems, database design, software engineering, and programming languages. He’s considered a leading authority on DB2/400, and his articles have appeared in NEWS/400, Database Programming & Design, Computer Language, and numerous other publications. Paul also consults and speaks frequently on database issues. Paul has developed applications on a variety of platforms and relational DBMS, including the AS/400, S/38, S/370, DEC, and PCs with DB2, Oracle, Ingres, and Access. He is the principle architect and developer of several commercial software products, including Flex/EDIT, a widely used Windows-based AS/400 programmer’s workbench. Paul has a B.A. in psychology from Georgia State University and an M.S. in computer science from the University of Oregon. He served on the University of Oregon faculty for eight years and ran his own consulting firm before starting Picante Software.