%TSQL.sys.cacheMsgXRef
hidden persistent class %TSQL.sys.cacheMsgXRef extends %Library.Persistent, %XML.Adaptor
SQL Table Name: %TSQL_sys.cacheMsgXRef
sys.messagesXref - lookup from one domain to another. sys_message cross reference to look up TSQL sys_messages give a Caché messageId and an errorCode. errorCode from most Caché messages is '0' but for $$$CacheError and $$$SQLError the errorCode corresponds to the $ZError and SQLCODE values respectively. This class is not intended for use in error reporting. It is simply a way to convert a message from one domain into an equivalent message in another domain.Property Inventory
Method Inventory
- findCache()
- findTSQL()
- linkCacheToTSQL()
- linkMessage()
- linkTSQLToCache()
- unlinkCacheToTSQL()
- unlinkTSQLToCache()
Properties
property cacheMessage as %Integer (XMLPROJECTION = "ATTRIBUTE") [ Required ];
Property methods: cacheMessageDisplayToLogical(), cacheMessageGet(), cacheMessageIsValid(), cacheMessageLogicalToDisplay(), cacheMessageNormalize(), cacheMessageSet(), cacheMessageXSDToLogical()
property errorCode as %String (MAXLEN = 255, XMLPROJECTION = "ATTRIBUTE") [ Required ];
Property methods: errorCodeDisplayToLogical(), errorCodeGet(), errorCodeIsValid(), errorCodeLogicalToDisplay(), errorCodeLogicalToOdbc(), errorCodeNormalize(), errorCodeSet()
property tsqlId as %Integer);
Property methods: tsqlIdDisplayToLogical(), tsqlIdGet(), tsqlIdIsValid(), tsqlIdLogicalToDisplay(), tsqlIdNormalize(), tsqlIdSet(), tsqlIdXSDToLogical()
Methods
Lookup a Caché messageId and errorCode given a sys_messages id
This is used commonly for a RAISEERROR statement
findTSQL - lookup a TSQL sys_messages id given a Caché messageId and errorCode
messageId is the Caché status id and errorCode is the submessage id.
classmethod linkCacheToTSQL(cacheStatus As %Integer, errorCode As %String(MAXLEN=255)="0", messageId As %Integer)
classmethod linkMessage(messageId As %Integer, cacheStatus As %Integer, errorCode As %String(MAXLEN=255)="0")
xref - link TSQL message to Cache message and invert the link
not every message link has an inverse because a given message only uses one
inverse message but it may be used by many inverse messages.
classmethod linkTSQLToCache(messageId As %Integer, cacheStatus As %Integer, errorCode As %String(MAXLEN=255)="0")
Indexes
index (IDK on cacheMessage,errorCode) [IdKey, Type = key];
Index methods: IDKCheck(), IDKDelete(), IDKExists(), IDKOpen(), IDKSQLCheckUnique(), IDKSQLExists(), IDKSQLFindPKeyByConstraint(), IDKSQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %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()
- %OnDetermineClass()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
Storage
Storage Model: CacheSQLStorage
Maps: 1
Map number 1 is named Master
thismap.Global: ^%qCacheSQL
^%qCacheSQL("mxc","tsql",{cacheMessage},{errorCode})
|
= |
|