We specialize in hard to find items
(1)
*Price and Stocks may change without prior notice
*Packaging of actual item may differ from photo shown
- Electrical items MAY be 110 volts.
- 7 Day Return Policy
- All products are genuine and original
About SQL/400 Developer's Guide
Product Description 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). Review A comprehensive, indispensable resource for students, programmers, and database administrators who need to learn about the AS/400 database. -- Bernadette Cinkoske, Assistant Professor, Ivy Tech State College A practical database design and SQL programming textbook specifically for AS/400 application developers. -- Frank G. Soltis, IBM AS/400 Chief Scientist and Prof. Computer Engineering, Univ. of Minnesota Both newcomers to the AS/400 and experienced AS/400 programmers will find SQL/400 Developer's Guide an excellent resource. -- Sharon L. Hoffman, Senior Analyst, TechReflections This book is where you should start learning SQL on the AS/400. -- Kent Milligan, DB2 & BI Solutions, AS/400 Partner World for Developers From the Author Structured Query Language/400 is IBMs 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 its 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 Developers Guide, youll be able to design and create professional level databases for real applications. This book also provides developers wi! th 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 wont 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, Microsofts SQL Server 2000, or other versions of DB2 UDB (e.g., on IBM mainframes). If thats your situation, you should be able to blast through most of the chapters and get a very rapid start with UDB/400. From the Inside Flap SQL/400 Developers 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 distrib
