Data Definition Language (DDL) Reference Manual (G06.24+)

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