Application Programming Interface Guide > Built-in Procedures > SQL Definition Sets > System SQL Definition Set
 
System SQL Definition Set
The System SQL definition set defines data types, exceptions, and constants for use with system utility procedures.
Location
/lib/util/System
Types Tab
The Types tab contains definitions for system utility data types.
Data Type Name
Base Type
Content
VARCHAR(65535)
EMailAddress
VARCHAR(1024)
MapValue
ROW
MessageValue
VARCHAR(64000)
OperationStatus
VARCHAR(255)
PropertyName
VARCHAR(255)
PropertyValue
VARCHAR(4096)
Text
VARCHAR(2147483647)
Exceptions Tab
The Exceptions tab lists the System utility exceptions. For an explanation of these exceptions, refer to the “TDV SQL Script” chapter of the TDV Reference Manual.
Exception Name
CannotExecuteSelectException
CannotOpenCursorException
CannotOpenNonSelectException
CursorAlreadyOpenException
CursorNotOpenException
CursorTypeMismatchException
DuplicateNameException
EvaluationException
IllegalArgumentException
IllegalStateException
NotAllowedException
NotFoundException
NotSupportedException
NullVariableException
ParseException
PipeNotOpenException
ProcedureClosedException
ProtocolException
SOAPFaultException
SecurityException
SystemException
TransactionClosedException
TransactionFailureException
UnexpectedRowCountException
UnopenedCursorException
Constants Tab
The Constants tab contains System utility constant definitions. The values of the constants marked with an asterisk (*) begin with a “System.” prefix.
Constant Name
Type
CACHED RESOURCE BUCKET PATH*
VARCHAR(255)
CACHED RESOURCE CACHE KEY*
VARCHAR(255)
CACHED RESOURCE ERROR MESSAGE*
VARCHAR(255)
CACHED RESOURCE INCREMENTAL MAINTENANCE LEVEL*
VARCHAR(255)
CACHED RESOURCE PARAM KEY*
VARCHAR(255)
CACHED RESOURCE PATH*
VARCHAR(255)
CACHED RESOURCE REFRESH OUTCOME*
VARCHAR(255)
CACHED RESOURCE TYPE*
VARCHAR(255)
CACHE DATASOURCE PATH*
VARCHAR(255)
CACHE IS INCREMENTAL*
VARCHAR(255)
CANCELED
VARCHAR(255)
CASE SENSITIVE IN COMPARISONS*
VARCHAR(255)
CLUSTER ID
VARCHAR(255)
CURRENT USER DOMAIN
VARCHAR(255)
CURRENT USER ID
VARCHAR(255)
CURRENT USER NAME
VARCHAR(255)
FAIL
VARCHAR(255)
IGNORE TRAILING SPACES IN COMPARISONS*
VARCHAR(255)
INCOMPLETE
VARCHAR(255)
NUM ROWS AFFECTED*
VARCHAR(255)
SERVER HOSTNAME
VARCHAR(255)
SERVER ID
VARCHAR(255)
SERVER JDBC PORT
VARCHAR(255)
SERVER VERSION
VARCHAR(255)
SERVER WEB PORT
VARCHAR(255)
SESSION ID
VARCHAR(255)
SUCCESS
VARCHAR(255)
TEXT HTML
VARCHAR(255)
TEXT PLAIN
VARCHAR(255)
TRANSACTION ID
VARCHAR(255)
TRIGGER EVENT NAME*
VARCHAR(255)
TRIGGER EVENT TYPE*
VARCHAR(255)
TRIGGER EVENT VALUE*
VARCHAR(255)
TRIGGER PATH*
VARCHAR(255)