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.

Load Definitions Support for SQLite Data Types

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.

Related Topics