Very Computer

Hi,

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
ON C:
ALIAS 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
)
IN USERSPACE1
========

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
function".)  SQLSTATE=58004
=========

I guess that it does not understand the "USER" casting function.
Would it be a bug on DB2 runing on Windows 2000 professional?

Thanks.

SQL Reference Chapter 6 SQL Statement - Create Table, "If USER is specified,
the data type of the column must be a character string with a length not
less than the length attribute of USER".  USER is not supported for
vargraphic data type.

Sherman

Quote:> Hi,

> 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
> ON C:
> ALIAS 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
> )
> IN USERSPACE1
> ========

> 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
> function".)  SQLSTATE=58004
> =========

> I guess that it does not understand the "USER" casting function.
> Would it be a bug on DB2 runing on Windows 2000 professional?

> Thanks.