Class %DeepSee.PMML.Dataset.SQL

persistent class %DeepSee.PMML.Dataset.SQL extends %DeepSee.PMML.Dataset.Table

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
	1	4

Summary

Properties
BootstrapCount	Fields	IdField	Name	SQL
TempTable

Methods
%%CLASSNAMELogicalToStorage	%%CLASSNAMEStorageToLogical	%AddToSaveSet	%AddToSyncSet
%BMEBuilt	%BuildIndicesAsync	%BuildIndicesAsyncResponse	%CheckConstraints
%CheckConstraintsForExtent	%ClassIsLatestVersion	%ClassName	%ComposeOid
%ConstructClone	%Create	%Delete	%DeleteExtent
%DeleteId	%DispatchClassMethod	%DispatchGetModified	%DispatchGetProperty
%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty	%DispatchSetProperty
%Exists	%ExistsId	%Extends	%GUID
%GUIDSet	%GetLock	%GetParameter	%GetSwizzleObject
%Id	%InsertBatch	%IsA	%IsModified
%IsNull	%KillExtent	%KillExtentData	%LoadFromMemory
%LockExtent	%LockId	%New	%NormalizeObject
%ObjectIsNull	%ObjectModified	%Oid	%OnBeforeAddToSync
%OnDeleteFinally	%OnDetermineClass	%OnOpenFinally	%OnSaveFinally
%Open	%OpenId	%OriginalNamespace	%PackageName
%PhysicalAddress	%PurgeIndices	%Reload	%RemoveFromSaveSet
%ResolveConcurrencyConflict	%RollBack	%Save	%SaveDirect
%SaveIndices	%SerializeObject	%SetModified	%SortBegin
%SortEnd	%SyncObjectIn	%SyncTransport	%UnlockExtent
%UnlockId	%ValidateIndices	%ValidateObject	%ValidateTable
Clear	ClearBootstraps	CreateTempTable	GenerateBootstraps
Get1DDistribution	GetAggregatesByCategory	GetBootstrap	GetFieldBySpec
GetRecordIds	GetValueCount	GetXDDistribution	HasField
SetFields

Properties

• property SQL as %String(MAXLEN="");

Methods

• classmethod %Create(pName As %String, pSQL As %String, ByRef pFields, ByRef pCreateTempTable As %String = "", pIdColumn As %String = "", Output pSC As %Status) as %DeepSee.PMML.Dataset.SQL

pFields is an array of the cube levels and measures to be included in the dataset pFields(n) = $lb(name, spec, tDataType, tOpType) field spec is the column name

Class Reference IRIS for UNIX 2024.1.2
Documentation Search