Load Definitions Facility for SQLite
The Load Definitions functionality is supported for SQLite.
Functionality
The Load Definitions facility for SQLite loads data based on generated columns, sometimes called computed columns.
Configuration
Before loading definitions from SQLite:
- Specify the SLE connector in the [DRIVERS] section of the IDE assignment file.
- Define the $SLE path in the [PATHS] section of the IDE assignment file.
For more detailed instructions, see Import Data Definitions From a DBMS.
Data Type Mapping
The Load Definitions utility maps SQLite data types to Uniface data types and packing codes. The following table lists these mappings.
|
SQLite Data Type |
Supported by Load Definitions |
Uniface Data Type |
Uniface Packing Code |
Remarks |
|---|---|---|---|---|
| boolean text | Yes | B | B1 | |
|
boolean integer |
Yes |
N |
B4 |
Range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807 |
| money | Yes | M | M4 | 9,223,372,036,854,775,808 to -9,223,372,036,854,775,807 |
|
char, character |
Yes |
S |
Cn |
n<=254 |
|
varchar, long varchar |
Yes |
S |
VCn |
n>=255 |
| clob | Yes | N | SCn | Range -8,388,608 to 8,388,607 |
| nchar | Yes | S | Wn | |
| nvarchar | Yes | S | VWn | |
| nclob | Yes | S | SWn, SW* | SWn in case Length > 0 else SW* |
| blob | Yes | R | SRn, SR* | SRn in case Length > 0 else SR* |
| date |
Yes |
D |
D |
Uniface does not allow BC dates. |
|
time |
Yes |
T |
T |
Uniface accuracy is limited to ticks. |
| datetime | Yes | E | E | |
|
numeric(p,s) |
Yes |
N |
N(p+1).s, N(p+1) |
pis precision (total number of digits); for Uniface p must be 30 max, field is skipped with a warning if p is larger. sis scale (number of decimal places); for Uniface s must be smaller than p, field is skipped with a warning if they are equal. s=0 generates N(p+1), rather than N(p+1).0 A ValRep is generated to enforce the exact DBMS max/min values. |
|
double |
Yes |
F |
F8 |
Uniface allows -1e+38 to 1e+38 Uniface will read the full database range. Storing outside the Uniface range generates an error. |
| Other data types |
Fields with a data type that is not known in the service are skipped with a warning message: TYPE_NOT_RECOGNIZED. |
