I'm trying to create a table in DB2, but the variable has 14 positions. With variable with size below 9 I have no problems. But when caught variables above that length I get the following error:
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: [IBM][CLI Driver][DB2] SQL0104N An unexpected token "(" was found following "". Expected tokens may include: "FIELDPROC CHECK GENERATED IMPLICITLY INLINE CONSTRAINT PRIMARY". SQLSTATE=42601 .
Code:
proc sql; create table db2lib.test2 as select var1 from work.test ; quit;
max size of var1 is 99999999911119.
... View more