Skip to main content

%Compiler.TSQL.sysSymbol

SQL Table Name: %Compiler_TSQL.sysSymbol

This is a persistent class that contains public symbol definitions for TSQL All sysSymbol id's are normalized to lower case.

Property Inventory

Method Inventory

Properties

property context as %String (XMLPROJECTION = "ATTRIBUTE") [ Required ];
The symbol context. By convention contexts are case insensitive and are normalized on insert to lower case.
Property methods: contextDisplayToLogical(), contextGet(), contextGetStored(), contextIsValid(), contextLogicalToDisplay(), contextLogicalToOdbc(), contextSet()
property dataType as %String (MAXLEN = 255);
Property methods: dataTypeDisplayToLogical(), dataTypeGet(), dataTypeGetStored(), dataTypeIsValid(), dataTypeLogicalToDisplay(), dataTypeLogicalToOdbc(), dataTypeNormalize(), dataTypeSet()
property expression as %String (MAXLEN = 3200);
Property methods: expressionDisplayToLogical(), expressionGet(), expressionGetStored(), expressionIsValid(), expressionLogicalToDisplay(), expressionLogicalToOdbc(), expressionNormalize(), expressionSet()
property symbol as %String (MAXLEN = 255, XMLPROJECTION = "ATTRIBUTE") [ Required ];
Property methods: symbolDisplayToLogical(), symbolGet(), symbolGetStored(), symbolIsValid(), symbolLogicalToDisplay(), symbolLogicalToOdbc(), symbolSet()

Methods

classmethod IDExists(K1 As %String, K2 As %String, ByRef id As %String = "") as %String
classmethod IDOpen(K1 As %String, K2 As %String, concurrency=-1, ByRef sc=1) as %String
classmethod addSymbol(symbolContext As %String = "", symbolName As %String = "", expression As %CacheString = "", type As %CacheString = "") as %Status
classmethod contextNormalize(%val As %String) as %String
classmethod export(filename As %String)
classmethod import(filename As %String) as %Status
classmethod symbolNormalize(%val As %String) as %String

Indexes

index (ID on context,symbol) [IdKey, Type = key];
Index methods: IDCheck(), IDDelete(), IDExists(), IDOpen(), IDSQLCheckUnique(), IDSQLExists(), IDSQLFindPKeyByConstraint(), IDSQLFindRowIDByConstraint()

Inherited Members

Inherited Methods

Storage

Storage Model: CacheStorage (%Compiler.TSQL.sysSymbol)

^%qCacheSQL("tsql","p")(ID)
=
expression
dataType
%%CLASSNAME
FeedbackOpens in a new tab