ADSM-L

[ADSM-L] AW: [ADSM-L] select statement

2007-11-27 10:27:11
Subject: [ADSM-L] AW: [ADSM-L] select statement
From: "Herrmann, Boris" <Boris.Herrmann AT ARAG DOT DE>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 27 Nov 2007 16:26:38 +0100
Thanks for your answer, but it's the same result:

tsm: SA023ADD>select node_name, passexp from nodes where PASSEXP!=0
ANR2034E SELECT: No match found using this criteria.
ANS8001I Rückkehrcode 11.


-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von goc
Gesendet: Dienstag, 27. November 2007 16:11
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: [ADSM-L] select statement


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>