Hi
According to the language reference(p76)
and Data Definition Guide(p98) you can specify
the datatype of a computed column.

The Create Table syntax is a bit unclear to me and
I could not see how to do it.(There is no example in
the documentation that I could find, that shows how)
I tried the following
DATEOFCOMPLETION COMPUTED BY (DATEOFCOLLECTION-1) DOM_TIMESTAMP,
DATEOFCOMPLETION DOM_TIMESTAMP COMPUTED BY (DATEOFCOLLECTION-1),
DATEOFCOMPLETION DOM_TIMESTAMP, COMPUTED BY (DATEOFCOLLECTION-1),
which neither did work.
The only clause that works is
DATEOFCOMPLETION COMPUTED BY (DATEOFCOLLECTION-1),

How do I specify "type" and "computed by" for the same field?

Thanks
Groete
Gerhardus