-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
12.5. Column Options
You can use the following options when specifying columns in the creation of a table or view. Any others properties defined will be considered as extension metadata.
Property
|
Data Type or Allowed Values
|
Description
|
---|---|---|
UUID
|
string
|
A unique identifier for the column
|
NAMEINSOURCE
|
string
|
If this is a column name on the FOREIGN table, this value represents name of the column in source database, if omitted the column name is used when querying for data against the source
|
CASE_SENSITIVE
|
'TRUE'|'FALSE'
| |
SELECTABLE
|
'TRUE'|'FALSE'
|
TRUE when this column is available for selection from the user query
|
UPDATABLE
|
'TRUE'|'FALSE'
|
Defines if the column is updatable. Defaults to true if the view/table is updatable.
|
SIGNED
|
'TRUE'|'FALSE'
| |
CURRENCY
|
'TRUE'|'FALSE'
| |
FIXED_LENGTH
|
'TRUE'|'FALSE'
| |
SEARCHABLE
|
'SEARCHABLE'|'UNSEARCHABLE'|'LIKE_ONLY'|'ALL_EXCEPT_LIKE'
|
column searchability, usually dictated by the data type
|
MIN_VALUE
| | |
MAX_VALUE
| | |
CHAR_OCTET_LENGTH
|
integer
| |
ANNOTATION
|
string
| |
NATIVE_TYPE
|
string
| |
RADIX
|
integer
| |
NULL_VALUE_COUNT
|
long
|
costing information. Number of NULLS in this column
|
DISTINCT_VALUES
|
long
|
costing information. Number of distinct values in this column
|