Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!texbell!vector!attctc!phil
From: phil@attctc.Dallas.TX.US (Phil Meyer)
Newsgroups: comp.databases
Subject: INTEGRA (stupid question)
Keywords: crummy manuals!
Message-ID: <11017@attctc.Dallas.TX.US>
Date: 16 Jan 90 15:49:52 GMT
Distribution: usa
Organization: The Unix(R) Connection, Dallas, Texas
Lines: 22

I am working on a little project using INTEGRA (which is based on an old
version of INFORMIX).  I am very familiar with INFORMIX, and am constantly
fustrated by the SCO manuals.

I have a stupid, fundamental, easy question that is driving me wild!

How do you test for null fields in INTEGRA?????

INFORMIX syntax would be like:

update tabname
	set fieldname = today
where
	fieldname is null;

PLEASE show me how to do this in INTEGRA, or pre-SQL INFORMIX!

+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
| Honesty is in the eye of      |  Phil Meyer                               |
|   the creditor.               |  Usenet: <backbone>!attctc!phil           |
|                               |  VoiceNet: (214) 625-4130                 |
+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+