Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

8.5. Data Type Metadata

SYS.DataTypes
This table supplies information on data types. See Section 4.1, “Supported Types”.
Column Name
Type
Description
Name
string
JBoss Data Virtualization design-time type name
IsStandard
boolean
Always false
IsPhysical
boolean
Always false
TypeName
string
Design-time type name (same as Name)
JavaClass
string
Java class returned for this type
Scale
integer
Max scale of this type
TypeLength
integer
Max length of this type
NullType
string
Nullability: "Nullable", "No Nulls", "Unknown"
IsSigned
boolean
Is signed numeric?
IsAutoIncremented
boolean
Is auto-incremented?
IsCaseSensitive
boolean
Is case-sensitive?
Precision
integer
Max precision of this type
Radix
integer
Radix of this type
SearchType
string
Searchability: "Searchable", "All Except Like", "Like Only", "Unsearchable"
UID
string
Data type unique ID
OID
integer
Unique ID
RuntimeType
string
JBoss Data Virtualization runtime data type name
BaseType
string
Base type
Description
string
Description of type

Warning

The OID column is no longer used on system tables. Use UID instead.