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.
Sally Woolrich — — source: Informix-list mailing list archive (1991-1998)
In article <45lo6u$aqc@hazel.Read.TASC.COM>
amiller@tasc.com "Andrew Miller" writes:
> kcj@netcom.com (Kate Juliff) wrote:
>
> >How do I check for nulls in a column of type INTEGER?
>
> Use an indicator variable for the host variable you're selecting into. The
> indicator variable will contain -1 if the field is NULL. See the "Indicator
> Variables" section of "Programming with ESQL/C for Windows" for more details.
This will show if the column *allows* NULLs, but not if it actually
*contains* NULLs. If the later is what is required, the data will
have to be searched in some manner.
--
============================================================================
Sally Woolrich | This mail contains my personal
sally@excelsis.demon.co.uk | views not those of my employer!
============================================================================
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.