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:[EMAIL PROTECTED] Im Auftrag von Herrmann,
Boris
Gesendet: Dienstag, 27. November 2007 16:07
An: ADSM-L@VM.MARIST.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
[EMAIL PROTECTED]
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
