Db2 Developer S Guide

Marketshare for DB2 has been growing steadily over the past five years and with the announcement of DB2 Universal Database V8 (T-Rex), the product has never had more momentum. "This is an excellent book . . . Mullins seems to have dumped his entire DB2 life experience into "DB2 Developer's Guide.""--Jonathon Sayles, "Relational Database Journal."

DB2 Developer's Guide, Fourth Edition is completely revised and updated, covering all the new features for Version 6 for OS/390. It includes a special chapter on how changes to the product impact its use. This book clarifies complex DB2 topics, provides performance and procedural advice for implementing well-designed DB2 applications, and describes what DB2 does behind the scenes. An entire chapter on Internet-related features is included.

DB2 Developer's Guide is the field's #1 go-to source for on-the-job information on programming and administering DB2 on IBM z/OS mainframes. Now, three-time IBM Information Champion Craig S. Mullins has thoroughly updated this classic for DB2 v9 and v10. Mullins fully covers new DB2 innovations including temporal database support; hashing; universal tablespaces; pureXML; performance, security and governance improvements; new data types, and much more. Using current versions of DB2 for z/OS, readers will learn how to: * Build better databases and applications for CICS, IMS, batch, CAF, and RRSAF * Write proficient, code-optimized DB2 SQL * Implement efficient dynamic and static SQL applications * Use binding and rebinding to optimize applications * Efficiently create, administer, and manage DB2 databases and applications * Design, build, and populate efficient DB2 database structures for online, batch, and data warehousing * Improve the performance of DB2 subsystems, databases, utilities, programs, and SQL stat DB2 Developer's Guide, Sixth Edition builds on the unique approach that has made previous editions so valuable. It combines: * Condensed, easy-to-read coverage of all essential topics: information otherwise scattered through dozens of documents * Detailed discussions of crucial details within each topic * Expert, field-tested implementation advice * Sensible examples

IBM and the rest of the computer industry are putting most of their DBMS development efforts into SQL. This reference provides the SQL/400 skills that a successful applications developer needs and shows how to create comprehensive, complex, and professional SQL/400 databases.

"The purpose of this book is to give advice and direction to Db2 application developers and programmers on writing efficient, well-performing programs ... The material is written for all Db2 professionals, whether you are coding on z/OS (the mainframe) or on Linux, Unix or Windows. When there are pertinent differences between the platforms it is explained in the text. The focus of the book is on programming, coding and developing applications"--

This is a guide designed to familiarize users with the DB2 standard while helping to optimize their use of the technology