ADSM-L

Re: [ADSM-L] select statement

2007-11-27 10:17:26
Subject: Re: [ADSM-L] select statement
From: Rainer Schöpf <rainer.schoepf AT PROTEOSYS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 27 Nov 2007 16:17:05 +0100
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

<Prev in Thread] Current Thread [Next in Thread>