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, ...
See more details below
Available through our Marketplace sellers.
Other sellers (Multimedia Set)
  • All (9) from $22.59   
  • New (4) from $34.00   
  • Used (5) from $22.59   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$34.00
Seller since 2005

Feedback rating:

(6)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Lebanon, Indiana, U.S.A. 2002 Trade Paperback New ! New, no remainder marks, no shelf wear, no surprises. Same day Shping. ! With unopened CD.

Ships from: Vauxhall, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$80.45
Seller since 2008

Feedback rating:

(218)

Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$93.50
Seller since 2015

Feedback rating:

(366)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$105.00
Seller since 2015

Feedback rating:

(241)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

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 Show Less

Product Details

  • ISBN-13: 9780131007710
  • Publisher: Pearson Education
  • Publication date: 11/26/2002
  • Series: IBM DB2 Certification Guide Series
  • Edition description: BOOK & CD-ROM
  • Pages: 598
  • Product dimensions: 7.02 (w) x 9.40 (h) x 0.94 (d)

Table of Contents

Preface
Pt. 1 Introduction to DB2 UDB for OS/390 and z/OS 1
Ch. 1 Product Overview 3
Ch. 2 Database Objects 45
Pt. 2 Structured Query Language 117
Ch. 3 Basic SQL Coding 119
Ch. 4 Advanced SQL Coding 153
Pt. 3 Developing Applications 177
Ch. 5 Using SQL in an Application Program 179
Ch. 6 Binding an Application Program 201
Ch. 7 Application Program Features 219
Ch. 8 Stored Procedures 239
Ch. 9 Testing and Debugging Applications 259
Ch. 10 Accessing Distributed Data 281
Pt. 4 Programming and Language Environments 303
Ch. 11 ODBC/CLI Programming 305
Ch. 12 DB2 Traditional Programming 331
Ch. 13 Java Programming 349
Ch. 14 Attachment Programming 393
Pt. 5 Advanced Programming Functions 421
Ch. 15 Object-Relational Programming 423
Ch. 16 Locking and Concurrency 465
Ch. 17 Application Performance and Optimization 485
App. A IBM Certified Solutions Expert - DB2 UDB Family Application Development 549
App. B: Resources 567
App. C DB2CERT Database DDL 579
Index 583
Read More Show Less

Preface

Preface

This book is an application programming guide to IBM's relational database server known as DB2 Universal Database Version 7.1 for OS/390 and z/OS. Its purpose is to provide guidance for taking the 514 DB2 Application Certification exam. However, it is much more than that. It is a compilation of information necessary to develop applications for DB2 V7 for OS/390 and z/OS. It also contains hints and tips from real-world experience in this environment.

The 514 exam covers DB2 on all platforms, including OS/390 and z/OS. For information regarding developing applications on platforms other than these two, please refer to the book authored by Tetsuya Shirai, John Barber, Mohan Saboji, Indran Naick, and Bill Wilkins—IBM DB2 UDB Application Development Environments (also published by Prentice Hall PTR).

Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of this book.

The book is divided into five parts.

Part 1: Introduction to DB2 UDB for OS/390 and z/OS

This section covers the fundamentals about the DB2 product family and the basics about the DB2 for OS/390 data structures. This information is the foundation on which applications are built in this environment. Understanding these concepts will lead to proper development with the appropriate tools.

Part 2: Structured Query Language

Part 2 covers the most robust query language: SQL (Structured Query Language). We look at basic SQL coding concepts and what the SQL language is comprised of. We then take a more in-depth look at some of the advanced features of the language.

Part 3: DevelopingApplications

This section is the heart of the book in terms of how to code an application in order to communicate with DB2. We first look at how to use SQL in an application program and then how to bind these programs to DB2 in order for them establish access paths to the DB2 data.

Some of the additional features of DB2 application programs are examined in terms of how we can use them to make our applications more useful and how to push more work into the DB2 engine. We then look at stored procedures, which provide us not only a way to encapsulate our code, but also a method for reducing traffic across the network. The new SQL procedure language is discussed as well as the use of the Stored Procedure Builder. We then examine how to best test and debug applications before they go into production. Finally, we look at how to access distributed data from our DB2 server within our application programs.

Part 4: Programming and Language Environments

Part 4 looks at how some of our more traditional programming languages, such as COBOL, C, C++, and REXX, access DB2. We then look at some more current methods, such as ODBC/CLI programming and Java. We also take a look at attachment programming techniques using CAF, CICS, and RRSAF.

Part 5: Advanced Programming Functions

In Part 5 we discuss the features of DB2 that support object-relational programming, such as user-defined functions, user-defined data types, and triggers. We also look at important aspects of application performance in terms of how to diagnose and tune problems. This includes looking at explain output and comparing it to available indexes and the SQL coding techniques.

Locking and concurrency is also a very important issue, because we have to be able to run several applications at the same time and to get the work through the system in an appropriate amount of time, while keeping the integrity of our data intact. In this section we look at all the options for locking and how to use them for best concurrency.

This book can be used as a self-study guide to help you prepare for the 514 DB2 Application Certification exam or simply as a guide to developing applications in a DB2 Universal Database V7.1 for OS/390 and z/OS environment. For information about the DB2 UDB family, refer to the other IBM certification books.

Read More Show Less

Introduction

Preface

This book is an application programming guide to IBM's relational database server known as DB2 Universal Database Version 7.1 for OS/390 and z/OS. Its purpose is to provide guidance for taking the 514 DB2 Application Certification exam. However, it is much more than that. It is a compilation of information necessary to develop applications for DB2 V7 for OS/390 and z/OS. It also contains hints and tips from real-world experience in this environment.

The 514 exam covers DB2 on all platforms, including OS/390 and z/OS. For information regarding developing applications on platforms other than these two, please refer to the book authored by Tetsuya Shirai, John Barber, Mohan Saboji, Indran Naick, and Bill Wilkins—IBM DB2 UDB Application Development Environments (also published by Prentice Hall PTR).

Those interested in becoming an IBM Certified Professional will want to review the sample questions at the end of this book.

The book is divided into five parts.

Part 1: Introduction to DB2 UDB for OS/390 and z/OS

This section covers the fundamentals about the DB2 product family and the basics about the DB2 for OS/390 data structures. This information is the foundation on which applications are built in this environment. Understanding these concepts will lead to proper development with the appropriate tools.

Part 2: Structured Query Language

Part 2 covers the most robust query language: SQL (Structured Query Language). We look at basic SQL coding concepts and what the SQL language is comprised of. We then take a more in-depth look at some of the advanced features of the language.

Part3: Developing Applications

This section is the heart of the book in terms of how to code an application in order to communicate with DB2. We first look at how to use SQL in an application program and then how to bind these programs to DB2 in order for them establish access paths to the DB2 data.

Some of the additional features of DB2 application programs are examined in terms of how we can use them to make our applications more useful and how to push more work into the DB2 engine. We then look at stored procedures, which provide us not only a way to encapsulate our code, but also a method for reducing traffic across the network. The new SQL procedure language is discussed as well as the use of the Stored Procedure Builder. We then examine how to best test and debug applications before they go into production. Finally, we look at how to access distributed data from our DB2 server within our application programs.

Part 4: Programming and Language Environments

Part 4 looks at how some of our more traditional programming languages, such as COBOL, C, C++, and REXX, access DB2. We then look at some more current methods, such as ODBC/CLI programming and Java. We also take a look at attachment programming techniques using CAF, CICS, and RRSAF.

Part 5: Advanced Programming Functions

In Part 5 we discuss the features of DB2 that support object-relational programming, such as user-defined functions, user-defined data types, and triggers. We also look at important aspects of application performance in terms of how to diagnose and tune problems. This includes looking at explain output and comparing it to available indexes and the SQL coding techniques.

Locking and concurrency is also a very important issue, because we have to be able to run several applications at the same time and to get the work through the system in an appropriate amount of time, while keeping the integrity of our data intact. In this section we look at all the options for locking and how to use them for best concurrency.

This book can be used as a self-study guide to help you prepare for the 514 DB2 Application Certification exam or simply as a guide to developing applications in a DB2 Universal Database V7.1 for OS/390 and z/OS environment. For information about the DB2 UDB family, refer to the other IBM certification books.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)