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

DDL Data Translation
Data Definition Language (DDL) Reference Manual—426798-002
C-11
DDL TYPE clause
(continued)
TYPE COMPLEX INT4
TYPE LOGICAL 1 BYTE
TYPE LOGICAL[2] BOOL
TYPE LOGICAL 4 INT2
TYPE ENUM ENUM
TYPE CHARACTER 8
OCCURS 100 TIMES
STRUCT(0:99);
BEGIN CHAR BYTE(0:9);
END;
TYPE BINARY 16
OCCURS 3 TIMES
INT(0:2);
TYPE SQL VARCHAR 10 BEGIN
INT LEN;
STRUCT VAL;
BEGIN CHAR BYTE(0:9);
END;
END
* TYPE SQL DATETIME
DAY TO MINUTE
CHAR BYTE(0:7)
TYPE SQL DATE CHAR BYTE(0:9)
TYPE SQL TIME CHAR BYTE(0:7)
TYPE SQL TIMESTAMP CHAR BYTE(0:25)
* TYPE SQL INTERVAL
MONTH 6
CHAR BYTE(0:6)
* Groups bit fields that can fit in the same word and generates a filler in the word’s type.
** 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-5. Sample DDL/TACL Data Translation Table (page 2 of 2)
Clause Type DDL Clause Specification TACL Data Type