Skip Headers
Oracle® Database Gateway for Adabas User's Guide
11g Release 2 (11.2)

Part Number E12074-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

A Data Type Conversion

This appendix contains the following section:

Conversion of Predict Metadata

The gateway converts Predict metadata data types in the advanced data dictionary (ADD) to Oracle data types as described in Table A-1.

Table A-1 Predict Metadata

ADD Data Type Oracle Data Type Details

A

VARCHAR2

A null-terminated string of alphanumeric characters; maximum length must be specified. An extra byte is required for the null flag.

B1

Number(3)

Unsigned byte integer.

Size: 1 byte

Range: 0 to +254

B2

Number(5)

Unsigned word integer.

Size: 2 bytes

Range: 0 to +65535

B4

Number(10)

Unsigned long integer.

Size: 4 bytes

Range: 0 to +4,294,967,294

F1

Number(3)

Signed byte integer.

Size: 1 byte

Signed range: -128 to +127

F2

Number(5)

Signed word integer.

Size: 2 bytes

Signed Range: -32768 to +32767

F4

Number(10)

Signed long integer.

Size: 4 bytes

Range: -2147483648 to 2147483647

F8

Number(19)

Signed long integer.

Size: 8 bytes

Range: -9223372036854775808 to +9223372036854775807

G4

FLOAT(23)

Single floating-point number (F_FLOAT).

Size: 4 bytes

Range: 0.29E-38 to 1.7E38

Precision: 6 digits

G8

FLOAT(49)

Double floating-point number (D_FLOAT)

Size: 8 bytes

Range: 029E-38 to 1.7E38

Precision: 16 digits

L

NUMBER(3)

Unsigned byte integer.

Size: 1 byte

Values: 1 for true, 0 for false

D

DATE

ODBC date format.

T

DATE

ODBC time format.

P

NUMBER

Packed decimal

Maximum number of digits: 31

Maximum fractions: 11

Length = int (number of digits/2) + 1 byte

N, U

NUMBER

Signed numeric string. A right overpunched sign is implemented.

Maximum number of digits: 31

Maximum fractions: 11


Conversion of Metadata from DDM Files

When you import metadata from a DDM file, the gateway maps the metadata data types as described in Table A-2.

Table A-2 Metadata from DDM Files

DDM/Natural Data Type ADD-Adabas Data Type Oracle Data Type Details

A

string

VARCHAR2

A null-terminated string of alphanumeric characters; maximum length must be specified. An extra byte is required for the null flag.

B1

Uint1

Number(3)

Unsigned byte integer.

Size: 1 byte

Range: 0 to +254

B2

Uint2

Number(5)

Unsigned word integer.

Size: 2 bytes

Range: 0 to +65535

B4

Uint4

Number(10)

Unsigned long integer.

Size: 4 bytes

Range: 0 to +4,294,967,294

I1

Int1

Number(3)

Signed byte integer.

Size: 1 byte

Signed range: -128 to +127

I2

Int2

Number(5)

Signed word integer.

Size: 2 bytes

Signed range: -32768 to +32767

I4

Int4

Number(10)

Signed long integer.

Size: 4 bytes

Range: -2147483648 to 2147483647

I8

Int8

Number(19)

Signed long integer.

Size: 8 bytes

Range: -9223372036854775808 to +9223372036854775807

F4

single

FLOAT(23)

Single floating-point number (F_FLOAT).

Size: 4 bytes

Range: 0.29E-38 to 1.7E38

Precision: 6 digits

F8

dfloat

Number(5)

Double floating-point number (D_FLOAT)

Size: 8 bytes

Range: 0.29E-38 to 1.7E38

Precision: 16 digits

L

Unit1

Number(3)

Unsigned byte integer.

Size: 1 byte

Values: 1 for true, 0 for false

D

ada_d_time

DATE

ODBC date format.

T

ada_time

DATE

ODBC time format.

P

decimal

NUMBER

Packed decimal

Maximum number of digits: 31

Maximum fraction: 11

Length = int (number of digits/2) + 1 byte

N, U

ada_numstr_s

NUMBER

Signed numeric string

Maximum number of digits: 31

Maximum fractions: 11