RE: How to Constrain smallint Positive Number only?
Hi John !
It is called DATA INTEGRITY, and it can be accomplished by the "CHECK"
feature in INFORMIX-SQL.
Just like the following:
abc smallint check abc > 0 (Please check the sintax)
Or you can ALTER the table in which case all rows must satisfied the
condition.
Regards,
----------------------------------------------------------------
Mario Estrada / SISTECO, S.A.
INFORMIX, / Phone (502) 3340214
Support Department / Fax (502) 3348447
----------------------------------------------------------------
John Glassman wrote the following:
----------
De: John Glassman[SMTP:MantisMan@atlas.loadstone.com]
Enviado: viernes 17 de enero de 1997 12:52
Para: informix-list@rmy.emory.edu
Asunto: How to Constrain smallint Positive Number only?
I'm try to figure out to restrict smallint data type to positive numbers
only...Can this be done. I'm using Informix Workgroup Server 7.1.
the schema I what to modify is like this:
create temp table table_name(column_name smallint default 1)
if this can't be done with smallint, is there another way.
All help appreciated....
--
John D. Glassman
Loadstone Advertising
1-716-889-5460
MantisMan@loadstone.com
http://www.loadstone.com