Skip to main content

%DeepSee.PMML.Dataset.SQL

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

SQL Table Name: %DeepSee_PMML_Dataset.SQL

Property Inventory

Method Inventory

Properties

property SQL as %String);
Property methods: SQLDisplayToLogical(), SQLGet(), SQLGetStored(), SQLIsValid(), SQLLogicalToDisplay(), SQLLogicalToOdbc(), SQLNormalize(), SQLSet()

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

Inherited Members

Inherited Properties

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: Storage (%DeepSee.PMML.Dataset.Base)

^%DeepSee.PMML.DatasetD(ID)
=
%%CLASSNAME
Name
IdField
Fields
BootstrapCount

Storage Model: Storage (%DeepSee.PMML.Dataset.Table)

^%DeepSee.PMML.DatasetD(ID,"TableDataset")
=
TempTable
TempTableClass

Storage Model: Storage (%DeepSee.PMML.Dataset.SQL)

^%DeepSee.PMML.DatasetD(ID,"SQLDataset")
=
SQL
TempTable
TempTableClass
FeedbackOpens in a new tab