Length Specifiers
Enterprise Access requires character length specifiers on string data types (char(n), varchar(n), nchar(n) and nvarchar(n)) when used in DDL statements. If length is not specified, it will trigger a gateway syntax error. This differs from the Ingres DBMS, which defaults the length to 1 if it is not specified.
For example, the following statement fails:
create table mytable (col1 varchar)
By specifying a length for varchar(n), the statement works:
create table mytable (col1 varchar(1))