Load Definitions Facility for Sybase

The Load Definitions functionality is supported for Sybase.

Functionality

The Load Definitions facility for Sybase loads tables, views, columns, and indexes.

It does not load relationships.

Configuration

Before loading definitions from Sybase:

  • Specify the SYB connector in the [DRIVERS] section of the IDE assignment file.
  • Define the $SYB 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 Sybase data types to Uniface data types and packing codes. The following table lists these mappings.

Load Definitions Support for Sybase Data Types

Sybase Data Type

Supported by Load Definitions

Uniface Data Type

Uniface Packing Code

 Remarks

bigint

Yes

N

I8

Range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
int Yes N I4 Range -2,147,483,648 to 2,147,483,647

smallint

Yes

N

I2

 Range -32,768 to 32,767
tinyint Yes N l1 Range 0 to 255 (negative numbers are not permitted)
identity Yes N An n=32
money Yes M M4 922,337,203,685,477.5807 to -922,337,203,685,477.5808
smallmoney Yes M M6 214,748.3647 to -214,748.3648

char, character

Yes

S

Cn

 n<=254

varchar, long varchar

Yes

S

VCn

 n>=255
text Yes S SC*  
image Yes R SR*  
unichar Yes S Wn  
univarchar Yes S VWn  
unitext Yes S SW*  
binary Yes R Rn  
varbinary Yes R R*  
bit Yes B B4  
datetime

Yes

E

E

smalldatetime

Yes

E

E9

decimal(p,s) and 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 during data entry and store validation; the ValRep range depends on p and s.

real

Yes

F

F4

Uniface allows -1e+38 to 1e+38

Uniface will read the full database range. Storing outside the Uniface range generates an error.

float

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      

The following data types are skipped with a warning message TYPE_NOT_SUPPORTED:

  • unsigned bigint
  • unsigned int
  • unsigned smallint
  • double precision
  • date
  • bigdatetime
  • time
  • bigtime
  • nchar
  • nvarchar
  • unibinary

Fields with a data type that is not known in the service are skipped with a warning message: TYPE_NOT_RECOGNIZED.

Related Topics