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

2007-11-27 Thread Herrmann, Boris
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

AW: [ADSM-L] select statement

2007-11-27 Thread Herrmann, Boris
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

AW: [ADSM-L] select statement

2007-11-27 Thread Thomas Rupp
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

AW: [ADSM-L] SELECT Statement

2007-02-07 Thread Herrmann, Boris
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