DDL Data Translation
Data Definition Language (DDL) Reference Manual — 426798-002
C -13
DDL TYPE clause
(continued)
TYPE BINARY 32
INT(32)
TYPE BINARY 32
UNSIGNED
INT(32)
TYPE BINARY 64
FIXED
TYPE BINARY 64,-16
FIXED(-16)
* TYPE BIT len
UNSIGNED(len)
TYPE FLOAT [32]
REAL
TYPE FLOAT 64
REAL(64)
TYPE COMPLEX
FIXED
TYPE LOGICAL 1
STRING
TYPE LOGICAL [2]
INT
TYPE LOGICAL 4
INT(32)
TYPE ENUM
INT
TYPE CHARACTER 8
OCCURS 100 TIMES
STRUCT [1:100];
BEGIN STRING BYTE [1:8]; END;
TYPE BINARY 16
OCCURS 3 TIMES
INT [1:3];
TYPE SQL VARCHAR
10
STRUCT BEGIN
INT LEN;
STRING VAL[1:10];
END
** TYPE SQL
DATETIME DAY TO
MINUTE
STRING BYTE [1:8]
TYPE SQL DATE
STRING BYTE [1:10]
TYPE SQL TIME
STRING BYTE [1:8]
TYPE SQL TIMESTAMP
STRING BYTE [1:26]
** TYPE SQL INTERVAL
MONTH 6
STRING BYTE [1:7]
* Field definition generates INT.
** Only one of the possible forms of the clause; see
DICTOBL Fields
on page D-12
, for the byte
lengths
of all forms of the clause.
Table C-6. Sample DDL/TAL Data Translation Table (page 2 of 2)
Clause Type
DDL Clause
Specification
pTAL or TAL Data Type
