ADSM-L

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

2007-11-27 10:34:01
Subject: [ADSM-L] AW: [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:33:34 +0100
Hi Thomas,

your select statement "select node_name, passexp from nodes where PASSEXP IS 
NULL" is the one we've searched for. 

Thanks,
Boris 


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


When I select the column with
  select * from syscat.columns where tabname='NODES' and colname='PASSEXP'

   TABSCHEMA: ADSM
     TABNAME: NODES
     COLNAME: PASSEXP
       COLNO: 30
INDEX_KEYSEQ: 
 INDEX_ORDER: 
    TYPENAME: INTEGER
      LENGTH: 0
       SCALE: 0
       NULLS: FALSE
     REMARKS: Password Expiration Period

NULLS are not allowed.

But when I do a
  select node_name, passexp from nodes where PASSEXP IS NULL 
or a
  select node_name, passexp from nodes where PASSEXP IS NOT NULL 
I always get results - strange.

TSM Server: 5.3.2.0

Thomas Rupp



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


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

 

 
Vorarlberger Illwerke AG ein Unternehmen von illwerke vkw
Rechtsform: Aktiengesellschaft, Sitz: Bregenz, Firmenbuchnummer: FN 59202 m, 
Firmenbuchgericht: LG Feldkirch, UID-Nr.: ATU 36737402

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