Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / ENSLIB namespace / %Exception.SQL
Private  Storage   

%Exception.SQL


class %Exception.SQL extends
%Exception.AbstractException

An SQL exception is instantiated using SQLCODE and %msg. It provides a convenient mechanism for reporting SQLCODE errors using exceptions. The resulting exception can be processed as a %Status value using the AsStatus() method or the original SQLCODE value along with the %msg value can be retrieved as Code and Data respectively. Authors of catch tException { } can test for an SQL exception using tException.%IsA("%Exception.SQL") to perform error handling and reporting specific to SQL.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
4


Summary


Methods
CreateFromSQLCODE SQLMessageString


Methods


• classmethod CreateFromSQLCODE(pSQLCODE As %Integer, pMessage As %String(MAXLEN="")) as %Exception.SQL
Instantiate an exception from SQLCODE and %msg.
• method SQLMessageString(pLevel As %Integer = 0) as %String
This returns a string that represents the SQL %msg string. Users should feel free to modify the format and content in subclasses