Author: Michelle DeVault <adsmigmo AT YAHOO DOT COM>
Date: Mon, 22 Jul 2002 08:13:16 -0700
How do you query what has been set with a "set" command? In particular I'd like to know what LICENSEAUDITPERIOD is set at. __________________________________________________ Do You Yahoo!? Yahoo! Aut
Author: Bill Dourado <bill.dourado AT ALSTEC DOT COM>
Date: Mon, 22 Jul 2002 16:20:57 +0100
Michelle query status OR query system Bill Dourado Michelle DeVault To: ADSM-L AT VM.MARIST DOT EDU <adsmigmo@YAH cc: OO.COM> Subject: query what you've set with "set" command Sent by: "ADSM: Dist St
You can issue either: QUERY STATUS or SELECT * FROM STATUS To get *only* the licenseauditperiod, you can issue: SELECT LICENSEAUDITPERIOD FROM STATUS Regards, Andy Andy Raibeck IBM Software Group Tiv
Author: "Cook, Dwight E" <DWIGHT.E.COOK AT SAIC DOT COM>
Date: Mon, 22 Jul 2002 10:07:50 -0700
HA ! I didn't remember the "query system" command so I gave it a run on my test environment and after a while got ** ** --> select stgpool_name,devclass_name,count(*) as "VOLUMES" from volumes group