Hi all,

Puzzling one - running Ubuntu 10.10 - Maverick Meerkat. Using
2.5.1 embedded server. Run isql - can create databases and perform
selects with no problems.

However, when I try to run

=================================
CREATE TABLE MY_TABLE (
TABLE_KEY INTEGER NOT NULL,
TABLE_VALUE INTEGER NOT NULL DEFAULT 0,
CONSTRAINT MY_TABLE_PK PRIMARY KEY
(TABLE_KEY));
====================================

I get the error

======================================
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 3, column 32
-DEFAULT
========================

It's not recognising the DEFAULT keyword?

When I run the statement without the "DEFAULT 0" it
runs smoothly.

Is there a problem with DEFAULT in 2.5.1 or am I missing
something obvious?

TIA and rgs,


Paul...