Jump to main content
HCL Logo Product Documentation
  • Customer Support
HCL OneDB 2.0.1
  • What's new in HCL OneDB™ 2.0.1
  • Getting Started
  • Installing
  • Administering
  • Migrating and upgrading
  • Data warehousing
  • Security
  • Client APIs and tools
  • SQL programming
  • JSON compatibility
  • Extending HCL OneDB™
  • Designing databases
  • Embedding HCL OneDB™
  • Release information
  • Troubleshooting HCL OneDB™
  1. Home
  2. Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
  3. Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in HCL OneDB™ databases.
  4. User-Defined Routines and Data Types Developer's GuideThe HCL OneDB™ User-Defined Routines and Data Types Developer's Guide describes how to define new data types and enable user-defined routines (UDRs) to extend HCL OneDB™.
  5. Extend the database server
  6. Routine management
  • Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
    • HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
    • Creating extensionsYou can create user-defined data types, routines, access methods, and other database objects to suit your needs. You can use application programming interfaces to write user-defined routines and applications that access data in HCL OneDB™ databases.
      • DataBlade® API Function ReferenceThe HCL OneDB™ DataBlade® API Function Reference describes the DataBlade® API functions and the subset of functions that the DataBlade® API supports.
      • DataBlade® Developers KitThe DataBlade® Developers Kit (DBDK) guides contain information about the tools you can use to develop and package DataBlade® modules, which extend the functionality of HCL OneDB™ databases.
      • J/Foundation Developer's GuideThe HCL® J/Foundation Developer's Guide describes how to write user-defined routines (UDRs) in the Java™ programming language for HCL OneDB™.
      • User-Defined Routines and Data Types Developer's GuideThe HCL OneDB™ User-Defined Routines and Data Types Developer's Guide describes how to define new data types and enable user-defined routines (UDRs) to extend HCL OneDB™.
        • Extend the database server
          • Create user-defined routines
          • Extend built-in data types
          • Extend operators
          • Build opaque data types
          • Extend operator classes
          • Routine management
        • A user-defined routine
        • Run a user-defined routine
        • Develop a user-defined routine
        • Extend data types
        • Extend operators and built-in functions
        • Create user-defined casts
        • Create user-defined aggregates
        • Create an opaque data type
        • Write support functions
        • Extend an operator class
        • Manage a user-defined routine
        • Improve UDR performance

Routine management

Manage a user-defined routine covers the following topics:
  • Assigning Execute privilege to a UDR
  • Reloading a UDR
  • Altering a UDR
  • Dropping a UDR

Improve UDR performance discusses ways that you can optimize the performance of your UDR.


Rate this topic


Comment on this topic.
  • Share: Email
  • Twitter
  • Disclaimer
  • Privacy
  • Terms of use
  • Cookie Preferences