I created a DB2 UTF-8 database running on Windows 2000 professional.
When I was trying to create a column with
vargraphic datatype with default value, it was causing an error as follows.
I am trying to find out what I am doing wrong or it is a bug on DB2 on Win2K
Any help or comment would be greatly appreciated...
Here is my sample DDL:
CREATE DATABASE MYTEST
USING CODESET UTF-8 TERRITORY US
COLLATE USING SYSTEM;
CREATE TABLE MYTABLE1
DBKY INTEGER NOT NULL ,
UPDATEUSER VARGRAPHIC(32) NOT NULL
WITH DEFAULT USER
The error I am getting to create table with the above SQL statement is:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "Unexpected cast
I guess that it does not understand the "USER" casting function.
Would it be a bug on DB2 runing on Windows 2000 professional?