Skip to main content

INFORMATION.SCHEMA.USERDEFINEDAGGREGATES

persistent class INFORMATION.SCHEMA.USERDEFINEDAGGREGATES extends %Library.Persistent [ Final ]

SQL Table Name: INFORMATION_SCHEMA.USER_DEFINED_AGGREGATES

Returns one row for each user defined aggregate that can be accessed by the current user in the current namespace.

Property Inventory

Parameters

parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.

Properties

property AGGREGATECHEMA as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = AGGREGATE_SCHEMA , Required ];
Name of the schema that contains the user defined aggregate
Property methods: AGGREGATECHEMADisplayToLogical(), AGGREGATECHEMAGet(), AGGREGATECHEMAIsValid(), AGGREGATECHEMALogicalToDisplay(), AGGREGATECHEMALogicalToOdbc(), AGGREGATECHEMANormalize(), AGGREGATECHEMASet()
property AGGREGATENAME as %String (COLLATION = "Upper", MAXLEN = 128) [ SqlFieldName = AGGREGATE_NAME , Required ];
Aggregate name
Property methods: AGGREGATENAMEDisplayToLogical(), AGGREGATENAMEGet(), AGGREGATENAMEIsValid(), AGGREGATENAMELogicalToDisplay(), AGGREGATENAMELogicalToOdbc(), AGGREGATENAMENormalize(), AGGREGATENAMESet()
property FINALIZEFUNCTION as %String (MAXLEN = 257) [ SqlFieldName = FINALIZE_FUNCTION ];
The Finalize Function of the User Defined Aggregate
Property methods: FINALIZEFUNCTIONDisplayToLogical(), FINALIZEFUNCTIONGet(), FINALIZEFUNCTIONIsValid(), FINALIZEFUNCTIONLogicalToDisplay(), FINALIZEFUNCTIONLogicalToOdbc(), FINALIZEFUNCTIONNormalize(), FINALIZEFUNCTIONSet()
property INITIALIZEFUNCTION as %String (MAXLEN = 257) [ SqlFieldName = INITIALIZE_FUNCTION ];
The Initialize Function of the User Defined Aggregate
Property methods: INITIALIZEFUNCTIONDisplayToLogical(), INITIALIZEFUNCTIONGet(), INITIALIZEFUNCTIONIsValid(), INITIALIZEFUNCTIONLogicalToDisplay(), INITIALIZEFUNCTIONLogicalToOdbc(), INITIALIZEFUNCTIONNormalize(), INITIALIZEFUNCTIONSet()
property ITERATEFUNCTION as %String (MAXLEN = 257) [ SqlFieldName = ITERATE_FUNCTION ];
The Iterate Function of the User Defined Aggregate
Property methods: ITERATEFUNCTIONDisplayToLogical(), ITERATEFUNCTIONGet(), ITERATEFUNCTIONIsValid(), ITERATEFUNCTIONLogicalToDisplay(), ITERATEFUNCTIONLogicalToOdbc(), ITERATEFUNCTIONNormalize(), ITERATEFUNCTIONSet()
property MERGEFUNCTION as %String (MAXLEN = 257) [ SqlFieldName = MERGE_FUNCTION ];
The Merge Function of the User Defined Aggregate
Property methods: MERGEFUNCTIONDisplayToLogical(), MERGEFUNCTIONGet(), MERGEFUNCTIONIsValid(), MERGEFUNCTIONLogicalToDisplay(), MERGEFUNCTIONLogicalToOdbc(), MERGEFUNCTIONNormalize(), MERGEFUNCTIONSet()
property OWNER as %String (MAXLEN = 160);
The owner of the User Defined Aggregate
Property methods: OWNERDisplayToLogical(), OWNERGet(), OWNERIsValid(), OWNERLogicalToDisplay(), OWNERLogicalToOdbc(), OWNERNormalize(), OWNERSet()
property PARAMETERLIST as %String (MAXLEN = 512) [ SqlFieldName = PARAMETER_LIST ];
The parameters and types of the User Defined Aggregate
Property methods: PARAMETERLISTDisplayToLogical(), PARAMETERLISTGet(), PARAMETERLISTIsValid(), PARAMETERLISTLogicalToDisplay(), PARAMETERLISTLogicalToOdbc(), PARAMETERLISTNormalize(), PARAMETERLISTSet()
property RETURNTYPE as %String (MAXLEN = 128) [ SqlFieldName = RETURN_TYPE ];
The datatype of the value returned by the User Defined Aggregate
Property methods: RETURNTYPEDisplayToLogical(), RETURNTYPEGet(), RETURNTYPEIsValid(), RETURNTYPELogicalToDisplay(), RETURNTYPELogicalToOdbc(), RETURNTYPENormalize(), RETURNTYPESet()

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: SQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^oddPROC

  • ^oddPROC({SchemaUpper},{TableUpper})
    =
    Node Delimiter Piece Name
    MERGE_FUNCTION
    10 AGGREGATE_NAME
    20 AGGREGATE_SCHEMA
    35 RETURN_TYPE
    36 OWNER
    37 PARAMETER_LIST
FeedbackOpens in a new tab