Database Design and Programming for DB2/400 - Softcover

Conte, Paul

Softcover

ISBN 10: 1882419065 ISBN 13: 9781882419067

Publisher: 29th Street Press,U.S., 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

The ultimate guide to DB2/400 programming
Paul Conte, a leading DB2/400 authority with extensive application development experience, provides easy-to-follow instruction in the proper way to create efficient, flexible databases on the AS/400. His explanations and advice assure that you'll handle your design and coding challenges with confidence and professional-level techniques.

This book provides complete coverage of both DDS, the traxditional approach to defining DB2/400 files, and of SQL/400, the industry-standard database language that is IBM's strategic language for the future of DB2/400. With this text, you can be sure of handling not only existing application databases, but also developing new SQL/400 databases. These skills will put you in the forefront of AS/400 application developers.

This book also provides an excellent introduction to practical database design techniques. You get a solid introduction to the relational database model, which underlies the whole DB2/400 architecture and the SQL language. On that foundation, the book explains a step-by-step method of modeling an organization's database requirements and developing a design for the necessary database files.

The text is designed for college-level courses and for independent study. Each chapter has numerous examples and exercises. The material is organized into four parts -- DDS, database design, SQL, and advanced DB2/400 features -- so you can focus on particular topics as needed. Appendices provide extensive reference material. You can use the book as your single DB2/400 resource, eliminating the need for many IBM manuals.

You will find "Database Design and Programming for DB2/400" immediately useful, whether you are just beginning to learn DB2/400 or you are an experienced developer. You will turn to this book time and time again for advice on the best way to design and program DB2/400 databases.

Comments from reviewers:

"With this book, you will hold in your hands a new standard for database textbooks." -- Frank Soltis, IBM, Chief Architect of the AS/400 and professor of computer engineering, University of Minnesota.

"This is the definitive DB2/400 text and an essential book for any AS/400 application developer." -- John Fulton, IBM, program manager, Data Technologies, AS/400 Division

"Finally! The integrated reference book that DB2/400 deserves. My AS/400 programmers are using Database Programming and Design for DB2/400 instead a stack of IBM manuals, and they are finding the information they need faster." -- Carson Soule, president, CAS, Inc.

"This book is the bible for creating a good foundation for modern AS/400 applications." -- Roger Pence in the "Microsoft and the AS/400" newsletter

"If you buy only one AS/40 book this year, get 'Database Design and Programming for DB2/400.' This is the ultimate guide to the AS/400's database." -- John Szwaronek, president, Universal Software

"This book is very extensive and is quite informative about the AS/400 database. It is a must for the professional's bookshelf." -- Cascade 38/400 User Group Newsletter, February 1997

"This textbook is masterfully written. The author is well-versed in database management concepts and DB2/400 processing. The student will gain insight and knowledge." -- Ted Tucker, CPT instructor, Metropolitan Community College

"This textbook provides clear, concise, and thorough coverage of AS/400 database concepts and techniques. A 'must read' for programmers as well as database personnel." -- Bernie Cinkoske, CIS instructor, IVY Tech State College

Edition details

• Publisher: 29th Street Press,U.S.
• Publication date: 1998
• Language: English
• ISBN 10: 1882419065
• ISBN 13: 9781882419067
• Binding: Paperback
• Number of pages: 772