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
Db2
Oracle
Microsoft SQL Server
MySQL
PostgreSQL
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`

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.

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.

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.

MySQL

RDBMS Data Type	Natural Data Format/Length
bigint	P19
binary (`n`)	B`n`
bit	N1
blob	B (DYNAMIC)
char (`n`)	A`n`
date	A10
datetime	A26
decimal	N10.0
decimal (`p`,`q`)	N`p`-`q`.`q`
double	F8
float	F4
int	I4
mediumblob	B (DYNAMIC)
mediumint	I4
mediumtext	A (DYNAMIC)
numeric	N10.0
numeric (`p`,`q`)	N`p`-`q`.`q`
longblob	B (DYNAMIC)
longtext	A (DYNAMIC)
text	A (DYNAMIC)
time	A26
timestamp	A26
tinyblob	B (DYNAMIC)
tinytext	A (DYNAMIC)
tinyint	I2
smallint	I2
varbinary (`n`)	B`n`
varchar (`n`)	A`n`
year	A4

PostgreSQL

RDBMS Data Type	Natural Data Format/Length
bigint	P19
bigserial	P19
boolean	L
bytea	B (DYNAMIC)
character (`n`)	A`n`
character varying (`n`)	A`n`
date	A10
decimal	N10.0
decimal (`p`,`q`)	N`p`-`q`.`q`
double precision	F8
integer	I4
interval	A20
numeric	N10.0
numeric (`p`,`q`)	N`p`-`q`.`q`
real	F4
serial	I4
smallint	I2
smallserial	I2
text	A (DYNAMIC)
time	A26
timestamp	A26