Hey,

I have the following:

CREATE TYPE MovieType AS ( title Char(30) , year Integer, inColor Char(1) ) MODE DB2SQL

I want to do something like this:

CREATE TABLE movie OF MovieType ( REF IS movieID USER GENERATED, PRIMARY KEY (title , year))

This don't work, because title and year can be null. but how can I define title and year not to be null?

Hi,

The only way is to change the base definition of your table and define the wsame as not null . for eg title char(30) not null, year integer not null. This is the solution as a primary keys can't have null values.

HTH

Nitin.