Database Design and Programming for DB2/400 - Softcover

Conte, Paul

Softcover

ISBN 10: 1882419065 ISBN 13: 9781882419067

Publisher: 29th Street Pr, 1998

Synopsis

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.

About this title

From the Publisher

Database Design and Programming for DB2/400 is a comprehensive introduction to the design and implementation of application databases on IBM's AS/400. This clear and authoritative text teaches you the following essential skills:

Coding Data Description Specifications (DDS) for physical and logical files

Entering CL commands to create DB2/400 files from DDS

Using field reference files

Accessing database files from RPG IV, RPG/400, COBOL/400, and other AS/400 high-level languages

The Relational Database Model as a foundation for DB2/400 and database design

Practical database design and data modeling

Using SQL/400 to define and access database files

Advanced DB2/400 features (including commitment control, the Open Query File command, database constraints, triggers, distributed database access, and others)

Database security

Data backup and recovery

About the Author

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.

Edition details

• Publisher: 29th Street Pr
• Publication date: 1998
• ISBN 10: 1882419065
• ISBN 13: 9781882419067
• Binding: Paperback
• Language: English
• Number of pages: 772