Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*not\s+like\s+underscore\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*not\s+like\s+underscore\s*$/: 4 ]

Total 4 documents matching your query.

1. not like underscore (score: 1): Author: Kai Hintze <kai.hintze AT ALBERTSONS DOT COM>; Date: Tue, 12 Nov 2002 11:15:44 -0700; Oh wiseness of wizards of tsm-flavored SQL, how do you match an underscore? I need to find node names that do not contain an underscore ('_'). I thought that would be no problem, just "select node_na; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2002-11/msg00511.html (11,403 bytes)
2. Re: not like underscore (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Tue, 12 Nov 2002 11:36:52 -0700; You can use ESCAPE '<escape char>' at the end of the WHERE clause to make this work. For example, to use '\' as the escape character: select node_name from nodes where node_name like '%\_%' escape '\; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2002-11/msg00512.html (12,710 bytes)
3. Re: not like underscore (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Tue, 12 Nov 2002 12:53:48 -0700; APAR is IC34959 for those interested in monitoring for a fix. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2002-11/msg00514.html (13,453 bytes)
4. Re: not like underscore (score: 1): Author: Kai Hintze <kai.hintze AT ALBERTSONS DOT COM>; Date: Tue, 12 Nov 2002 12:19:05 -0800; Unfortunately getting the node names is only the first part. Where I am really heading is something like: select node_name, sum(capacity) as "MB available", sum(capacity * pct_util / 100) as "MB used; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2002-11/msg00523.html (12,238 bytes)

Current List: 1 - 4
Page: [1]