• Object Management Extension User Guide
•  1. Introduction
  • Audience
  • In This Guide
  • System-specific Text in This Guide
  • Terminology Use in This Guide
  • Syntax Conventions Used in This Guide
•  2. Introducing Object Management Extension
  • In This Chapter
  •  What Is Object Management Extension?
    • Structure and Symbol Definitions
    • Demonstration Data Types
  •  How You Add Data Types and Functions
    • Required Contents of the Code
    • Data Type Definitions
    • Function Definitions
    • Function Instance Definitions
    • Coercion Routines
    • Installation and Testing of the New Code
  • Object Management Extension Restrictions
•  3. Understanding DBMS Server Requirements for User-Defined Data Types
  • In This Chapter
  • How the DBMS Server Uses the Code
  • Requirements for User-written Code
  • Requirements for Data Type Coercion
  • IDs for Data Types and Functions
  • User-defined Data Types and the Copy Statement
  • Large Objects
•  4. Defining Data Types
  • In This Chapter
  • Data Type Definition
  • Structure IIADD_DT_DFN Fields
  •  Required Routines for Data Type Definition
    • Function Parameters
    • Structure scb_error
    • Structure II_DATA VALUE
    •  The Structure of db_data
      • Internal Structure of a Decimal Value
  •  compare Routine--Compare Two Data Elements
    • Inputs
    • Outputs
    • Returns
  •  dbtoev Routine--Determine External Data Type
    • Inputs
    • Outputs
    • Returns
  •  dhmax Routine--Create Default Maximum Histogram Value
    • Inputs
    • Outputs
    • Returns
  •  dhmin Routine--Create Default Minimum Histogram Value
    • Inputs
    • Outputs
    • Returns
  •  getempty Routine--Get an Empty Value
    • Inputs
    • Outputs
    • Returns
  •  hashprep Routine--Prepare Value for Hash Key
    • Inputs
    • Outputs
    • Returns
  •  helem Routine--Create a Histogram Element for Data Value
    • Inputs
    • Outputs
    • Returns
  •  hg_dtln Routine--Provide Type and Length for Histogram Value
    • Inputs
    • Outputs
    • Returns
  •  hmax Routine--Create Histogram Value for Maximum Value
    • Inputs
    • Outputs
    • Returns
  •  hmin Routine--Create Histogram Value for Minimum Value
    • Inputs
    • Outputs
    • Returns
  •  keybuild Routine--Build a Key from the Value
    • Inputs
    • Outputs
    • Returns
  •  length_check Routine--Check for Valid Length
    • Inputs
    • Outputs
    • Returns
  •  minmaxdv Routine--Provide Min/Max Values and Lengths
    • Inputs
    • Outputs
    • Returns
  •  seglen Routine--Determine Length of Each Long Segment
    • Inputs
    • Outputs
    • Returns
  •  tmcvt Routine--Convert Data Type to Displayable Format
    • Inputs
    • Outputs
    • Returns
  •  tmlen Routine--Determine Display Length
    • Inputs
    • Outputs
    • Returns
  •  value_check Routine--Check for Valid Values
    • Inputs
    • Outputs
    • Returns
  •  xform Routine--Transform Long Types into Segments
    • Inputs
    • Outputs
    • Returns
•  5. Defining Functions
  • Required Definitions
  • Structure IIADD_FO_DFN
•  6. Defining Function Instances
  • Function Instance Definition
  • Structure IIADD_FI_DFN
  • Length Definition of Result Data Type
  • External Lenspec Routine--Return Result Length of Specified Value
  • Complementary Function Instances
  • Sorting of the Function Instance Definition Array
  • Methods for Defining Function Instances for Large Objects
  •  Ingres-supplied Filter Functions
    • Direct Manipulation of Large Objects
  •  II_INFORMATION Operation--Return Maximum Length of Peripheral Object Segments
    • Inputs
    • Outputs
    • Returns
  •  II_GET Operation--Get Next Segment
    • Inputs
    • Outputs
    • Returns
  •  II_PUT Operation--Add a New Segment
    • Inputs
    • Outputs
    • Returns
  •  II_COPY Operation--Move a Peripheral Object
    • Inputs
    • Outputs
    • Returns
•  7. Passing Definitions to the DBMS Server
  • IIudadt_register Routine
  • Structure IIADD_DEFINITION Fields
  •  Server Routines Provided
    • The ii_cb_trace Routine--Output Provided Trace Messages
    • The ii_error_fcn Routine--Place Error Information in Status Control Block
    • The ii_lo_handler_fcn Routine--Move Through Large Object Segments
    • The ii_init_filter_fcn Routine--Set Up Filter Function
    • The ii_filter_fcn Routine--Perform Operation by Calling a User Routine
•  8. Installing and Testing Data Types
  • In This Chapter
  • How You Install New Data Types in a Windows Environment
  •  How You Install New Data Types in a VMS Environment
    • Template Command File--Create the Shared Image
    •  II_USERADT Logical--Set Disk Location of the Shared Image
      • Definition of II_USERADT in a Test Installation
  • How You Install New Data Types in a UNIX Environment
  • Testing the New Data Type Code
•  9. Writing Aggregate Functions
  • In This Chapter
  • Aggregate Function
  • Function Definitions for Aggregates
  • Code for an Aggregate Function
•  A. Checklist for Creating Data Types
  • How You Create Data Types in Windows
  • How You Create Data Types in UNIX
  • How You Create Data Types in VMS

Ingres 10.2

How You Create Data Types in VMS