SQL/400 Developer's Guide - Softcover

Mike Cravitz; Paul Conte

Softcover

ISBN 10: 1882419707 ISBN 13: 9781882419708

Publisher: 29th Street Pr, 2000

Synopsis

A comprehensive Perl reference contains a CD-Rom with sample scripts and applications from the book, in addition to appendices for the advanced Perl user with an alphabetized function reference for the built-in Perl functions, and much more. Original. (All Users).

About this title

About the Author

Paul Conte is president of PCES, an educational and consulting company in Eugene, Oregon. He's also a senior technical editor for iSeries NEWS 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 UDB for AS/400, and his articles have appeared in iSeries NEWS, DB2 Magazine, Database Programming & Design, and numerous other publications. He has authored or co-authored four other books, including Database Design and Programming for DB2/400 (29th Street Press, 1997) and SQL Server 2000 Developer's Guide (Osborne/McGraw-Hill, 2000). Paul has a B.A. in phychology from Georgia State University and an M.S. in computer science from the University of Oregon.

Mike Cravitz is a technical editor for iSeries NEWS with more than 30 years of application development experience. A consultant, instructor; and highly regarded author on SQL, RPG, Cobol, and ILE topics, Mike was formerly a systems engineer with IBM marketing in support of the IBM midrange. He holds a B.A. in mathematics from California State University at Northridge and an M.A. in mathematics from the univeristy of California at Los Angeles. Mike is also the author if the book ILE by Example (29th Street Press, 2002).

From the Inside Flap

SQL/400 Developer s Guide provides start-to-finish coverage of SQL/400, IBM's strategic language for the AS/400's integrated database. This essential text provides comprehensive explanations and numerous examples to help you: Create new databases, tables, views, and indexes with SQL/400. Define primary key, unique, foreign key, and check constraints to enforce data integrity. Master the Select, Update, Insert, and Delete statements from an introductory level to complex queries and transactions. Use advanced SQL features such as user-defined data types, user-defined functions, and stored procedures to speed application development. Protect transaction integrity using DB2 UDB/400 commitment control. Exploit SQL/400 extensions to increase database performance. Implement applications following "best practices" for efficiency and maintainability. Code easy-to-maintain trigger programs. Enforce tight, but flexible, security to protect data. Use Distributed Relational Database Architecture to retrieve and update data on distributed AS/400s. Model and design databases using entity relationship diagrams. With this book, you ll be able to design and create professional-level databases for production applications. Paul Conte and Mike Cravitz are leading DB2 UDB/400 authorities with extensive application development experience. They ve joined forces to create a book that will help new, as well as experienced, AS/400 developers design and code with speed and confidence. Along with in-depth instruction and advice on implementation, the book includes an excellent introduction to practical database design techniques. You get a clear explanation of the relational database model, which underlies the whole DB2 UDB/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 tables and views. This text is designed for professional application developers and college-level students who want to become developers. All the essential SQL/400 and related DB2 UDB/400 topics are covered from an introductory to an advanced level. Each chapter has numerous examples and exercises, including two complete RPG IV and ILE COBOL/400 sample programs that illustrate all the major programming techniques necessary for a production SQL/400 application. Extensive appendices provide quick references on SQL/400 statements and database-related Command Language commands. You ll find SQL/400 Developer s Guide immediately useful, whether you re just beginning to learn SQL/400 or you re an experienced developer. And you ll turn to this book time and time again for quick answers to the best way to design and program AS/400 database applications.

Excerpt. © Reprinted by permission. All rights reserved.

Introduction to UDB/400, the AS/400 s Integrated Database Chapter Overview: This chapter introduces the concept of a database and describes DB2 Universal Database for AS/400 (UDB/400), the database management system that runs on the AS/400. You ll get a general idea of how the AS/400 and its operating system, OS/400, are architected. You ll also get an overview of UDB/400 physical and logical files and how they are used with Structured Query Language (SQL).

Edition details

• Publisher: 29th Street Pr
• Publication date: 2000
• ISBN 10: 1882419707
• ISBN 13: 9781882419708
• Binding: Paperback
• Language: English
• Number of pages: 508