SQL/400 Developer's Guide / Edition 2

Overview

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.

From the Authors: Structured Query Language/400 is IBM's strategic language for defining and manipulating DB2 UDB for AS/400 databases. IBM has recently stated that the proprietary Data Description Specifications and built-in RPG and COBOL I/O extensions are not being enhanced to support new database features. That means if you plan to take full advantage of the AS/400 integrated database, you need to know SQL. And, if you plan to use Java, you need to know SQL because JDBC (Java Database Connectivity) uses SQL to access the AS/400 database. Finally, if you plan to keep your application programming skills current, you need to know SQL because it's the database language used on all major platforms. This book provides a comprehensive explanation of SQL/400 to students and practicing programmers. Once you master the topics covered in SQL/400 Developer's Guide, you'll be able to design and create professional level databases for real applications. This book also provides developers with extensive advice on database design, as well as programming. We cover SQL data definition language (DDL) and data manipulation (DML) in detail. But we go beyond that to explain essential areas such as security, transaction integrity (commitment control), object and row locking, stored procedures, and trigger programs. The book includes numerous examples, tables, appendices, and detailed technical explanations so in most cases, you won't need any AS/400 manual to create, manage, and use UDB/400 tables and other objects. This edition is based on Version 4 Release 5 of UDB/400, RPG IV, and ILE COBOL/400. This is an ideal book for programmers coming from other database platforms, such as Oracle, Microsoft's SQL Server 2000, or other versions of DB2 UDB (e.g., on IBM mainframes). If that's your situation, you should be able to blast through most of the chapters and get a very rapid start with UDB/400.

Read More