From the Publisher
The ultimate guide to DB2/400 programmingPaul 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