from the command select * from syscat.tables you can find a table called: TABSCHEMA: ADSM TABNAME: MGMTCLASSES CREATE_TIME: 1996-04-25 14:31:19.025065 COLCOUNT: 12 INDEX_COLCOUNT: 3 UNIQUE_INDEX: TRUE REMARKS: Management classes
then you can do: tsm: ADSM>select * from syscat.columns where tabname='MGMTCLASSES' and from that you can see/find a column name called: TABSCHEMA: ADSM TABNAME: MGMTCLASSES COLNAME: CLASS_NAME then you can do (your answer): tsm: ADSM>select class_name from mgmtclasses CLASS_NAME ------------------ 10_DAY_RETENTION 30_DAY_RETENTION 5_DAY_RETENTION 60_DAY_RETENTION 90_DAY_RETENTION etc... -----Original Message----- From: Wholey, Joseph (TGA\MLOL) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 2:40 PM To: [EMAIL PROTECTED] Subject: SQL command Looking for an SQL command that will show me nodes by management class. Can anyone help? Regards, Joe Wholey TGA Distributed Data Services Merrill Lynch Phone: 212-647-3018 Page: 888-637-7450 E-mail: [EMAIL PROTECTED]