ADSM-L

Re: [ADSM-L] select statement

2007-11-27 10:11:37
Subject: Re: [ADSM-L] select statement
From: goc <gooooc AT GMAIL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 27 Nov 2007 16:11:06 +0100
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
>
>
>
>
>

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