Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+SV\:\s+List\s+of\s+files\s+in\s+filespace\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*\[ADSM\-L\]\s+SV\:\s+List\s+of\s+files\s+in\s+filespace\s*$/: 5 ]

Total 5 documents matching your query.

1. [ADSM-L] SV: List of files in filespace (score: 1): Author: Christian Svensson <Christian.Svensson AT CRISTIE DOT SE>; Date: Fri, 29 May 2009 07:59:55 +0200; Hi, Yes you can, my way to do it is probably not the best one but it works. Select filespace_name as Filespace, hl_name as Directory, ll_name as Filename from backup where node_name='NODENAME' But be; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-05/msg00386.html (11,720 bytes)
2. Re: [ADSM-L] SV: List of files in filespace (score: 1): Author: Arthur Poon <apoon AT MODESTOGOV DOT COM>; Date: Fri, 29 May 2009 08:43:19 -0700; When I execute the SQL statement I got the following errors tsm: ADSMSERV>select filespace_name as filespace, hl_name as directory, ll_names as file_name from backup where node_name='COMAPPS' ANR2906; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-05/msg00399.html (12,593 bytes)
3. Re: [ADSM-L] SV: List of files in filespace (score: 1): Author: Richard Sims <rbs AT BU DOT EDU>; Date: Fri, 29 May 2009 11:48:18 -0400; Do select * from syscat.tables to see actual table names.; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-05/msg00400.html (10,953 bytes)
4. Re: [ADSM-L] SV: List of files in filespace (score: 1): Author: David McClelland <david.mcclelland AT NETWORKC.CO DOT UK>; Date: Fri, 29 May 2009 17:16:05 +0100; Try 'BACKUPS', rather than 'BACKUP' as your table name and that should see you right. /David Mc London, UK http://www.linkedin.com/in/dmcclelland When I execute the SQL statement I got the following; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-05/msg00402.html (13,343 bytes)
5. Re: [ADSM-L] SV: List of files in filespace (score: 1): Author: Mark Mooney <mmooney AT AISCONSULTING DOT NET>; Date: Fri, 29 May 2009 17:34:11 -0700; I also find it helpful to use the ODBC driver to check out the table names in excel. Thanks, Mooney Try 'BACKUPS', rather than 'BACKUP' as your table name and that should see you right. /David Mc Lon; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2009-05/msg00407.html (13,800 bytes)

Current List: 1 - 5
Page: [1]