Data Conversion for Adabas or RDBMS

The conversion tables shown in this section list the Natural data formats and their corresponding data types in an Adabas database or in a relational database management system (RDBMS).

The generation of DDMs from an RDBMS requires the conversion from RDBMS-specific data types to Natural data formats. For general information on data access and data conversion, see the list of related documentation in Related Topics.

For information on using large and dynamic variables and/or fields, refer to the section DDM Generation and Editing for Varying Length Columns in the Statements documentation.

This section covers the following topics:

Adabas
Adabas D
Adabas SQL Server
DB2
Informix
Oracle
Sybase
Microsoft SQL Server
Related Topics

Adabas

Data Type	Adabas Data Format	Natural Data Format/Length
alphanumeric	A (`n`)	A`n`
binary	B (`n`)	B`n`
fixed	F (`n`) but: F8	I`n` I4
float	G (`n`)	F`n`
packed	P (`n`)	P (`2 * n - 1`)
unpacked	U (`n`)	N`n`
wide character (Unicode)	W (`n`)	U (`n/2 rounded down`)

Adabas D

RDBMS Data Type	Natural Data Format/Length
boolean	L
char (`n`)	A`n`
date	A10
fixed (`p`,`q`)	N`p`-`q`,`q`
float	F8
integer	I4
long	A (DYNAMIC)
long varchar	A (DYNAMIC)
smallint	I2
string	A`n`
time	A8
timestamp	A26
varchar	A`n`

Adabas SQL Server

RDBMS Data Type	Natural Data Format/Length
char(5)	A5
char(253)	A253
decimal(5)	N5
decimal(10.4)	N6.4
double precision	N10.6
float(1...21)	N2.6
float(22...53)	N10.6
integer	I4
numeric(5)	N5
numeric(10.4)	N6.4
real	F4
smallint	I2

DB2

RDBMS Data Type	Natural Data Format/Length
date	A10
blob	B (DYNAMIC)
clob	A (DYNAMIC)
dbclob	U (DYNAMIC)
decimal(5)	N5
decimal(10.4)	N6.4
fixed character(5)	A5
float	F`n`
graphic(`n`)	U`n`
longvar	A (DYNAMIC)
longvarg	A (DYNAMIC)
large integer	I4
scientific notation	N10.6
small integer	I2
special data	A253
system date and time	A10
time	A8
timestamp	A26
varchar	A`n`
varg	2*A`n`
vargraphic(`n`)	U`n`

Notes:

Prerequisite for the use of the data types blob, clob, dbclob, graphic and vargraphic with DB2 is Entire Access Version 6.2.1 and above.
In DB2, the data types graphic and vargraphic are only available when the database has been generated with a statement like CREATE DATABASE mydb USING CODESET UTF-8 TERRITORY US. Refer to your local DB2 documentation for further information.

Informix

RDBMS Data Type	Natural Data Format/Length
byte	A`n`
char(`n`)	A`n`
date	A10
datetime	A26
decimal(`p`,`q`)	N`p`-`q`,`q`
float	F8
integer	I4
interval	A17
money	N14.2
nchar(2*`n`)	U`n`
nvarchar(2*`n`)	U`n`
real	F4
serial	I4
smallfloat	F4
smallint	I2
text	A`n`
varchar(`n`)	A`n`

Note:
Prerequisite for the use of the data types nchar and nvarchar with Informix is Entire Access Version 6.2.1 and above.

Oracle

RDBMS Data Type	Natural Data Format/Length
blob	B (DYNAMIC)
char (`n`)	A`n`
clob	A (DYNAMIC)
date	A10
decimal (`p`,`q`)	N`p`-`q`,`q`
double precision	F8
float	F4
integer	I4
long	A (DYNAMIC)
long raw	B (DYNAMIC)
nchar(`n`)	U`n`
nclob	U (DYNAMIC)
number	N`n`
nvarchar2(`n`)	U`n`
raw (`n`)	B`n`
real	F4
rowid	A`n`
smallint	I2
timestamp	A26
varchar	A`n`
varchar2 (`n`)	A`n`

Notes:

Do not confuse the data types long and long raw, and clob and blob in the same table.
Prerequisite for the use of data type timestamp is Entire Access Version 6.2.1 and above. The timestamp variants timestamp with time zone and timestamp with local time zone are not supported.
Prerequisite for the use of the data types nchar, nvarchar2 and nclob with Oracle is Entire Access Version 6.2.1 and above.

Sybase

RDBMS Data Type	Natural Data Format/Length
binary (`n`)	B`n`
bit	N1
char (`n`)	A`n`
datetime	A26
float	F8
int	I4
money	N15.4
real	F4
smalldatetime	A26
smallint	I2
smallmoney	N6.4
timestamp	B8
tinyint	I2
unichar(`n`)	U`n`
univarchar(`n`)	U`n`
varbinary (`n`)	B`n`
varchar (`n`)	A`n`

Note:
Prerequisite for the use of the data types unichar and univarchar with Sybase is Entire Access Version 6.2.1 and above. These data types can only be used with the Entire Access ctlib interface for Sybase.

Microsoft SQL Server

RDBMS Data Type	Natural Data Format/Length
binary (`n`)	B`n`
bit	N1
char (`n`)	A`n`
datetime	A26
float	F8
image	B (DYNAMIC)
int	I4
money	N15.4
nchar(2*`n`)	U`n`
ntext	U (DYNAMIC)
nvarchar(2*`n`)	U`n`
real	F4
smalldatetime	A26
smallint	I2
smallmoney	N6.4
text	A (DYNAMIC)
timestamp	B8
tinyint	I2
varbinary (`n`)	B`n`
varchar (`n`)	A`n`

Note:
Prerequisite for the use of the data types nchar, nvarchar and ntext with Microsoft SQL Server is Entire Access Version 6.2.1 and above. Furthermore, these data types require the use of the MSSQLODBC driver of Entire Access Version 6.2.1 and above.