Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+select\s+question\s+on\s+backups\s+table\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+select\s+question\s+on\s+backups\s+table\s*$/: 5 ]

Total 5 documents matching your query.

1. [ADSM-L] select question on backups table (score: 1): Author: "Lee, Gary" <GLEE AT BSU DOT EDU>; Date: Tue, 7 May 2013 13:03:11 +0000; Tsm server 5.5.4. Windows client 6.3.0 Will the following select show me all backups at and below the designated subdirectory? select * from backups where node_name='CASTSTORAGE' AND - upper(hl_NAME); /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2013-05/msg00036.html (11,008 bytes)
2. Re: [ADSM-L] select question on backups table (score: 1): Author: "Prather, Wanda" <Wanda.Prather AT ICFI DOT COM>; Date: Tue, 7 May 2013 14:13:44 +0000; To get other subdirectories, you'll need to add the wildcard designator % (without a wildcard, "like" is the same as "=") upper(hl_NAME) like '%\BIOMECHANICS\DICKIN\FATIGUE STUDY\FATIGUE STUDY%' Tsm; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2013-05/msg00040.html (11,653 bytes)
3. Re: [ADSM-L] select question on backups table (score: 1): Author: Thomas Denier <Thomas.Denier AT JEFFERSONHOSPITAL DOT ORG>; Date: Tue, 7 May 2013 10:22:15 -0400; --Gary Lee wrote: -- Selects against the Version 5 'backups' table tend to be very time consuming. It would almost certainly be faster to use client facilities to find the backup files. Note that a T; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2013-05/msg00041.html (11,680 bytes)
4. Re: [ADSM-L] select question on backups table (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Tue, 7 May 2013 10:28:53 -0400; Hi Gary, If this is a Windows client, you do not need to upper-case the HL_NAME as long as the actual pattern you specify is in upper case. This is because file system backups on Windows are always s; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2013-05/msg00043.html (13,474 bytes)
5. Re: [ADSM-L] select question on backups table (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Tue, 7 May 2013 10:39:15 -0400; This is pretty close to what I also responded with. However, it will pick up entries not only in '..\FATIGUE STUDY', but also in '..\FATIGUE STUDY - PRELIMINARY' or '..\FATIGUE STUDY2', which might; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2013-05/msg00044.html (13,763 bytes)

Current List: 1 - 5
Page: [1]