g, 27. November 2007 16:17
An: ADSM-L@VM.MARIST.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
CO
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:[EMAIL PROTECTED] Im Auftrag
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
REMARK
Hello Andy,
thanks!! That's it. Now I've 100% the output I have searched for ;-)
Mit freundlichen Grüßen / with kind regards,
Boris Herrmann
Produktion / Heterogene Systeme
ARAG IT GmbH
ARAG Platz 1, 40472 Düsseldorf
Tel: +49 (0)211 964-1137
F