PPT Slide

• DB2 for Common Servers (Version 2)

  • User-defined column types (UDTs/distinct types)
  • User-defined functions (UDFs)
  • Binary/character large objects (BLOBs/CLOBs)

• Distinct types: new data types for columns

  • Ex: create distinct type US_Dollar as Real with comparisons;
  • US_Dollar is an available UDT with functions =, <>, <, <=, >, >=, US_Dollar(Real), Real(US_Dollar)

• User-defined functions: associated operations

  • create function CA_Tax (US_Dollar) returns US_Dollar external name 'money!US_Dollar' language C;

DB2 Universal Database, Version 5

Previous slide

Next slide

Back to first slide

View graphic version