Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [ENSLIB] >  [%TSQL] >  [sys] >  [cacheMsgXRef]
Private  Storage   

sys.messagesXref - lookup from one domain to another. sys_message cross reference to look up TSQL sys_messages give a messageId and an errorCode. errorCode from most messages is '0' but for $$$ObjectScriptError 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.


Parameters Properties Methods Queries Indices ForeignKeys Triggers
3 7 1


cacheMessage errorCode tsqlId

%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 findCache findTSQL linkCacheToTSQL
linkMessage linkTSQLToCache unlinkCacheToTSQL unlinkTSQLToCache


• property cacheMessage as %Integer(XMLPROJECTION="ATTRIBUTE");
• property errorCode as %String(MAXLEN=255,XMLPROJECTION="ATTRIBUTE");
• property tsqlId as %Integer(XMLPROJECTION="");


• classmethod findCache(messageId As %Integer) as %String
Lookup a messageId and errorCode given a sys_messages id This is used commonly for a RAISEERROR statement
• classmethod findTSQL(messageId As %Integer, errorCode As %String(MAXLEN=255)="0") as %Integer
findTSQL - lookup a TSQL sys_messages id given a messageId and errorCode messageId is the 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 message object 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")
• classmethod unlinkCacheToTSQL(cacheStatus As %Integer, errorCode As %String(MAXLEN=255)="0", messageId As %Integer)
• classmethod unlinkTSQLToCache(messageId As %Integer, cacheStatus As %Integer, errorCode As %String(MAXLEN=255)="0")


•index (IDK on cacheMessage,errorCode) [IdKey];

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