Re: I-SQL question on constraints

Posted in 1994

Jonathan Leffler — 11 Jul 1994 22:28:05 -0400 — source: Informix-list mailing list archive (1991-1998)

>From: storm@geog.utah.edu (John Storm) >Subject: I-SQL question on constraints >Date: 11 Jul 1994 23:50:10 GMT >X-Informix-List-Id: <news.7556> >What is I-SQL's version of, e.g. > CREATE DOMAIN CITIES CHAR(5) > CONSTRAINT ICCITIES > CHECK ( VALUE IN ( 'Athens', 'New York' )) >or even, > CREATE ASSERTATION constraint CHECK (conditional-exp ) These are features of SQL92, and the 6.00 Informix products do not support them. Thus, you haven't missed anything in the manual, nor has the manual omitted anything -- you are simply seeking unimplemented functionality. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>