Data Type Syntax
SQL Syntax
[NUMERIC DATA TYPE | CHAR/BINARY DATA TYPE | DATE/TIME DATA TYPE]
Numeric Data Type
[BIT | TINYINT | SMALLINT | INTEGER | INT | BIGINT | REAL | DOUBLE [PRECISION] | DECIMAL/DEC/NUMERIC (precision).(scale) | FLOAT [(float_precision)]]
Char/Binary Data Type
[CHAR/CHARACTER/NCHAR/VARCHAR/NVARCHAR/BINARY/BIN/VARBINARY (max_length) | LONGVARCHAR | LONGVARBINARY | LONGNVARCHAR | NCLOB]
Date/Time Data Type
[DATE | TIME | TIMESTAMP [(timestamp_precision)]]
Adabas Data Type Syntax
[NATURAL DATE/TIME/TIMESTAMP | SEQNO [(seqno_level)]]