RE: SQL-Error-Code 591???
this is...
CREATE TABLE PRUEBA ( DAY datetime year to fraction(3) default datetime
(1900-01-01 00:00:00.000) year to fraction NOT NULL)
----- Original Message -----
From: Peter Ulrich <p.ulrich@corag.de>
To: <informix-list@iiug.org>
Sent: Thursday, July 20, 2000 9:18 AM
Subject: Re: SQL-Error-Code 591???
> Hi Pankaj,
>
> thanx for your reply!
>
> Unfortunately your suggestion didn't solve the problem.
> I get a syntax error (code 201) instead,
> as well as with the following variations:
>
>
> CREATE TABLE SOME_NAME
> (
> execution_dat datetime year to fraction(3)> default datetime year to fraction(3) (1900-01-0100:00:00.000) not null
> )
>
> nor this:
>
> CREATE TABLE SOME_NAME
> (
> execution_dat datetime year to fraction(3)> default datetime (1900-01-0100:00:00.000) not null
> )
>
>
> Any more ideas?
>
> Regards Peter
>
>
>