Developing user-defined functions

By creating user-defined functions, you can extend the capabilities of DB2 by adding function definitions that can be applied in the database engine.

With the Development Center, you can:

  • Create user-defined functions using wizards or the built-in editor:
    • SQL table and scalar user-defined functions
    • User-defined functions that read MQSeries messages
    • User-defined functions that access OLE DB data sources
    • User-defined functions that extract data from XML documents
  • Build and register the user-defined function on the database server
  • Run or debug the user-defined function
  • View and edit the user-defined function source code
  • Import the user-defined function into your project from the database or the file system
  • Export the user-defined function from your project to the file system
  • Deploy the user-defined function to a target database
  • Copy the user-defined function from one database server to another