IBM Books

Application Development Guide


User-defined Distinct Types (UDTs)

  • Why Use UDTs?
  • Defining a UDT
  • Resolving Unqualified UDTs
  • Examples of Using CREATE DISTINCT TYPE
  • Example: Money
  • Example: Job Application
  • Defining Tables with UDTs
  • Example: Sales
  • Example: Application Forms
  • Manipulating UDTs
  • Examples of Manipulating UDTs
  • Example: Comparisons Between UDTs and Constants
  • Example: Casting Between UDTs
  • Example: Comparisons Involving UDTs
  • Example: Sourced UDFs Involving UDTs
  • Example: Assignments Involving UDTs
  • Example: Assignments in Dynamic SQL
  • Example: Assignments Involving Different UDTs
  • Example: Use of UDTs in UNION

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

    [ DB2 List of Books | Search the DB2 Books ]