Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Marco Greco — — source: Informix-list mailing list archive (1991-1998)
Hi Paul,
No can do! today (current, user, etc, etc) is not allowed in in check
clauses, I'm afraid
Ciao,
Marco
______________________________________________________________________________
Marco Greco <marco@informix.com> Standard disclaimers apply!
Informix faq http://www.iiug.org/techinfo/faq/informix.htm
4glworks http://www.ctonline.it/~marcog
Informix on Linux http://www.ctonline.it/~marcog/ifmxlinux.htm
Paul Mahoney wrote:
>
> Anyone know why I get the following in a create table statment:
>
> check (sale_start_date >= today),
> # ^
> # 201: A syntax error has occurred.
> #
>
> This is Informix OnLine 7.2 and the column sale_start_date is declared:
>
> sale_start_date date not null,
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.