DB2 Server for VSE & VM: Application Programming

Chapter 11. Special Topics

Partial Table-of-Contents

  • Using Datetime Values with Durations
  • Using Durations
  • Resolving Peculiarities of Date Arithmetic
  • Summarizing Addition Operations
  • Summarizing Subtraction Operations
  • Using Field Procedures
  • Assigning Field Procedures to Columns
  • Understanding Field Procedure Rules
  • Input from an Application Program
  • Output to an Application Program
  • Comparison
  • Referential Integrity
  • Scalar Functions
  • Column Functions
  • Concatenation
  • The IN and BETWEEN Predicates
  • The LIKE Predicate
  • Sorting
  • Null Values
  • Unions and Joins
  • Sub-SELECTS
  • Using CMS Work Units (DB2 Server for VM)
  • Using Work Units in Application Programs
  • Processing the First SQL Statement in the Work Unit
  • Invoking Another Application Program
  • Invoking Applications in CMS SUBSET
  • Processing Applications Concurrently
  • Accessing the Database from Different Points in the Program
  • Copying Data across Databases
  • How Locking Works with CMS Work Units
  • Environmental Considerations
  • Performance Considerations
  • Ensuring Data Integrity
  • Ensuring Entity Integrity
  • Using Unique Constraints
  • When Creating a View
  • Ensuring Referential Integrity
  • Defining Terms
  • Ensuring Referential Integrity in New Tables
  • Adding Referential Integrity to Existing Tables
  • Managing Table Relationships
  • Modifying Applications to Ensure Integrity
  • Modifying Data in Tables Containing Referential Constraints
  • Restrictions on Using Delete Rules
  • Generating SQL Statements in Response to Table Modifications
  • Enforcing Referential Integrity
  • Removing Referential Constraints
  • Switching Application Servers
  • Identifying Switching Options
  • Comparing Switching to Other Methods (DB2 Server for VM)
  • How to Switch Servers (DB2 Server for VSE)
  • Accessing a New Application Server
  • Illustrating Sample Code
  • Preprocessing the Program on Multiple Application Servers
  • Condition Handling with LE/VSE (DB2 Server for VSE)

    • Contents

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]