Data Dictionary Data ModelSingle-row table for test cases and value retrieval of singleton SQL functions.
Catalog: DataDictionary
Schema: Invantive
Alias: dal
Primary Keys: DUMMY_INT32
Label: Single Row
This is a read-only table. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
Table Columns
The columns of the table DUAL are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
dummy_blob_null |
byte[] |
|
☐ |
|
dummy_blob |
byte[] |
Dummy BLOB |
☑ |
|
dummy_bool_null |
boolean |
|
☐ |
|
dummy_bool |
boolean |
Dummy Boolean |
☑ |
|
dummy_char_null |
char |
|
☐ |
|
dummy_char |
char |
|
☑ |
|
dummy_date_null |
datetime |
|
☐ |
|
dummy_date |
datetime |
Dummy Date |
☑ |
|
dummy_datetime_null |
datetime |
|
☐ |
|
dummy_datetime |
datetime |
Dummy Date/Time |
☑ |
|
dummy_decimal_null |
decimal |
|
☐ |
|
dummy_decimal |
decimal |
Dummy Decimal |
☑ |
|
dummy_double_above |
double |
|
☑ |
|
dummy_double_below |
double |
|
☑ |
|
dummy_double_null |
double |
|
☐ |
|
dummy_double |
double |
Dummy Double |
☑ |
|
dummy_float_null |
float |
|
☐ |
|
dummy_float |
float |
Dummy Float |
☑ |
|
dummy_guid_null |
guid |
|
☐ |
|
dummy_guid |
guid |
Dummy GUID |
☑ |
|
dummy_int16_null |
int16 |
|
☐ |
|
dummy_int16 |
int16 |
Dummy Integer (16-bits) |
☑ |
|
dummy_int32_null |
int32 |
|
☐ |
|
dummy_int32 |
int32 |
Dummy Integer (32-bits) |
☑ |
|
dummy_int64_null |
int64 |
|
☐ |
|
dummy_int64 |
int64 |
Dummy Integer (64-bits) |
☑ |
|
dummy_string_int64 |
string(20) |
|
☐ |
|
dummy_string_null |
string(1) |
|
☐ |
|
dummy_string |
string(1) |
Dummy String |
☑ |
|
dummy_uint16 |
uint16 |
Dummy uint16 |
☑ |
|
dummy_uint32 |
uint32 |
Dummy uint32 |
☑ |
|
dummy_uint64 |
uint64 |
Dummy uint64 |
☑ |
|
17-05-2021 11:57 Version 20.1.419-BETA+3191
