I suspect the value of passexp can be NULL, so it should be
select node_name,passexp from nodes where not (passexp is null)
Rainer
------------------------------------------------------------------------
On Tue, 27 Nov 2007, goc wrote:
> try this -->
>
> select node_name, passexp from nodes where PASSEXP!=0
>
> On Nov 27, 2007 4:06 PM, Herrmann, Boris <Boris.Herrmann AT arag DOT de>
> wrote:
> > Hello,
> >
> > we would like to get a list of nodes where the option "PASSEXP" is unequal
> > 0. We used the following SQL statement:
> >
> > tsm: SA023ADD>select node_name, passexp from nodes where passexp<>0
> > ANR2034E SELECT: No match found using this criteria.
> > ANS8001I Rückkehrcode 11.
> >
> > But we definitely have nodes where the option passexp is not set. So this
> > field is complete empty. Why wouldn't our select statement show this nodes?
> >
> > Any help is appreciate.
> >
> > With kind regards,
> >
> >
> >
> > Boris Herrmann
> >
> > Produktion / Heterogene Systeme
> >
> >
> >
> > ARAG IT GmbH
> >
> > ARAG Platz 1, 40472 Düsseldorf
> >
> >
> >
> > Tel: +49 (0)211 964-1137
> >
> > Fax: +49 (0)211 964-1155
> >
> > Boris.Herrmann AT ARAG DOT de
> >
> > www.ARAG.de <http://www.arag.de/>
> >
> >
> >
> >
> >
> > Geschäftsführer: Ottmar Liebler, Hanno Petersen
> >
> > Sitz und Registergericht: Düsseldorf, HRB 10934
> >
> > USt-ID-Nr.: DE 119 356 473
> >
> >
> >
> >
> >
>
--------------------------------------------------------
ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz
Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung
Mail: rainer.schoepf AT proteosys DOT com
Phone: +49-(0)6131-50192-41
Fax: +49-(0)6131-50192-11
WWW: http://www.proteosys.com/
--------------------------------------------------------
ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz
Amtsgericht Mainz HRB 7508 - USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner
|