Hi...
i have currently installed db2 version 9.1.2 on my AIX machine...
No matter what i do,.... VARCHAR2 just doesn't seem to be working!
This is the error i ketp getting after i ran a simple create statement...
$db2 "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
Do let me know if you know of a workaround apart fromthe use of VARCHAR
I am not sure at which version of DB2 varchar2 was introduced so you want to make sure maybe that your version is sufficient and update 1st in case.
Here are 3 links regarding varchar2 - all 3 links talk of compatibility modes that can be set in DB2 registry and stuff that has to be set before creating the DB. Maybe checkout if this is your case:
hey thanks a ton for the links man...
the site said that it's done at the database level
it looks like il have to create another database after enabling varchar2_compact and then migrate to it....