DB2 Universal Database for OS/390 v7.1 Application Certification Guide

Overview

• IBM's definitive DB2 UDB V7.1 application development reference and exam study guide for the OS/390 and z/OS platforms
• An official IBM self-study guide for the DB2 UDB V7.1 Family Application Development Exam (#514)
• Expert DB2 programming tips, techniques, and guidelines from application development experts
• Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and more
• CD-ROM contains complete DB2 application development sample exam
• The definitive, authoritative guide to DB2 OS/390 application development certification
• Covers data structures, SQL, stored procedures, programming/language environments, debugging, tuning, and much more
• Includes a full section on object-relational programming and other advanced techniques
• Sample test questions help you prepare for the IBM DB2 UDB V7.1 Family Application Development Exam (#514)

About the CD

The CD-ROM included with this book contains a complete DB2 UDB V7.1 Family Application Development Exam (#514) sample exam.

IBM DB2 UDB Version 7.1 for OS/390 and z/OS delivers unparalleled performance, scalability, and reliability in today's enterprise business environments. Now, there's a complete, authoritative guide to developing applications with DB2 UDB V7.1 in both OS/390 and z/OS environments—and preparing for the IBM DB2 UDB V7.1 Family Application Development Exam (#514).

This comprehensive day-to-day guide to DB2 UDB application development is also the only book that delivers the depth of knowledge professionals need to pass IBM's challenging application developmentOS/390 and z/OS platforms.

IBM Gold Consultant Susan Lawson presents hundreds of useful tips, practical techniques, and expert guidelines for every facet of DB2 UDB application development and every stage of the development process for both OS/390 and z/OS platforms Coverage includes:

• Foundations for effective DB2 development, including an overview of the DB2 UDB product family and DB2 for OS/390 data structures
• SQL: basic concepts and coding techniques through advanced OLAP features, star schemas, and star joins
• Stored procedures, including the SQL procedure language and IBM's Stored Procedure Builder
• Best practices for application testing, debugging, and performance tuning
• The full range of DB2 development tools, including ODBC/CLI, Java(tm), COBOL, C, C++, REXX, CAF, CICS, and RRSAF
• Object-relational programming, including user-defined functions, user-defined data types, and triggers
• In-depth coverage of locking and concurrency

Whether you're developing for DB2 UDB V7.1 in an OS/390 or z/OS environment, managing DB2 UDB V7.1 application development, preparing for DB2 UDB V7.1 Family Application Development, or all three, DB2 UDB for OS/390 Version 7.1 Application Certification Guide will be your single most valuable resource.

IBM DB2 Series

Read More