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 traditional 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. Database Design and Programming for DB2/400 also provides an excellent introduction to practical database design techniques. You get a solid introduction to the relational database model, which underlies the whole DB! 2/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're 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.
"Sinopsis" puede pertenecer a otra edición de este libro.
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)
Data backup and recoveryAbout 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.
"Sobre este título" puede pertenecer a otra edición de este libro.
Descripción 29th Street Press, 1998. Paperback. Estado de conservación: New. Never used!. Nº de ref. de la librería P111882419065
Descripción 29th Street Press, 1998. Paperback. Estado de conservación: New. book. Nº de ref. de la librería M1882419065