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
|