Re: [ADSM-L] select statement
2007-11-27 10:11:37
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
>
>
>
>
>
|
|
|