Class Reference
IRIS for UNIX 2019.3
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%DeepSee] >  [SQL] >  [CatalogQueries]
Private  Storage   

class %DeepSee.SQL.CatalogQueries

Inventory

Parameters Properties Methods Queries Indices ForeignKeys Triggers
15 4


Summary

Methods
GetCubesClose GetCubesExecute GetCubesFetch GetDimensionColumnsClose
GetDimensionColumnsExecute GetDimensionColumnsFetch GetDimensionTablesClose GetDimensionTablesExecute
GetDimensionTablesFetch GetUnsupportedFeaturesClose GetUnsupportedFeaturesExecute GetUnsupportedFeaturesFetch
HasUnsupportedFeatures


Methods

• private classmethod Close(ByRef qHandle) as %Status
• private classmethod Fetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod GetCubesClose(ByRef qHandle As %Binary) as %Status
• classmethod GetCubesExecute(ByRef qHandle As %Binary, pIncludeUnsupported As %String(VALUELIST=",none,warning,error")="warning") as %Status
• classmethod GetCubesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod GetDimensionColumnsClose(ByRef qHandle As %Binary) as %Status
• classmethod GetDimensionColumnsExecute(ByRef qHandle As %Binary, pTableName As %String) as %Status
• classmethod GetDimensionColumnsFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod GetDimensionTablesClose(ByRef qHandle As %Binary) as %Status
• classmethod GetDimensionTablesExecute(ByRef qHandle As %Binary, pCubeName As %String) as %Status
• classmethod GetDimensionTablesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod GetUnsupportedFeaturesClose(ByRef qHandle As %Binary) as %Status
• classmethod GetUnsupportedFeaturesExecute(ByRef qHandle As %Binary, pCubeName As %String) as %Status
• classmethod GetUnsupportedFeaturesFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod HasUnsupportedFeatures(pCubeName As %String, Output pUnsupportedFeatures, Output pSC As %Status = $$$OK) as %Boolean [ SQLProc = HasUnsupportedFeatures ]
Checks if a cube or subject area uses features that are not supported by default through the SQL projections. For example, the presence of an %OnGetFilterSpec() method on the cube class may indicate certain runtime code is expected that cannot be guaranteed to run by direct SQL access.

Queries

• query GetCubes(pIncludeUnsupported As %String(VALUELIST=",none,warning,error")="none")
Selects ClassName As %String, CubeName As %String, DisplayName As %String, Type As %String, PackageName As %String, UnsupportedFeatures As %String
Retrieves a list of all cubes accessible through SQL, along with relevant metadata, including whether the cube has any features not supported through direct SQL access. These cubes can be excluded from the result through the pIncludeUnsupported parameter, which defaults to "warning", meaning only cubes that will definitely not work are excluded from the result.
• query GetDimensionColumns(pTableName As %String)
Selects ColumnName As %String, DisplayName As %String, Usage As %String, References As %String
• query GetDimensionTables(pCubeName As %String)
Selects TableName As %String, DisplayName As %String
• query GetUnsupportedFeatures(pCubeName As %String)
Selects Severity As %String, Message As %String


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.