ERROR while using VARCHAR2

vgr12386 · #1 (**permalink**) 08-10-09, 05:04

hi i tried using VARCHAR2 and this is the error i got:

Code:

create table tst (name VARCHAR2(30));

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "VARCHAR2" was found following "eate table TST
(name".  Expected tokens may include:  "VARCHAR".  SQLSTATE=42601

Have any of you'll got similar errors?

im am currently using Db2 version 9.1.2 on an AIX server