All databases
sysxtypes contains one row for each extended, Java-SQL datatype.
See Java in Adaptive Server Enterprise for more information about Java-SQL classes and datatypes.
The columns for sysxtypes are:
Name |
Datatype |
Description |
|---|---|---|
xtid |
int |
System-generated ID for the extended type. |
xtstatus |
int |
Internal status information. Unused. |
xtmetatype |
int |
Unused. |
xtcontainer |
int |
The ID of the JAR file containing the class. Can be NULL. |
xtname |
varchar(255) null |
The name of the extended type. |
xtsource |
text null |
Source code for the extended type. Unused. |
xtbinaryinrow |
varbinary(255) null |
Object code for the extended type. For Java classes, it contains the class file. Data is stored in-row up to a length of 255 bytes. |
xtbinaryoffrow |
image |
Object code for the extended type. For Java classes, it contains the class file. Data is stored off-row as an image column. |
Unique clustered index on xtid
Unique nonclustered index on xtname
