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
- AGGREGATECHEMA
- AGGREGATENAME
- FINALIZEFUNCTION
- INITIALIZEFUNCTION
- ITERATEFUNCTION
- MERGEFUNCTION
- OWNER
- PARAMETERLIST
- RETURNTYPE
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
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferredIndices()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
Storage
Gray indicates storage defined by superclasses.
Storage Model: SQLStorage
Maps: 1
Map number 1 is named Master
thismap.Global: ^oddPROC
^oddPROC({SchemaUpper},{TableUpper})
|
= |
|