SQL and delimiting fields

2005-08-04 Thread Richard Mochnaczewski
Hi *, I need to audit some backups we have on our TSM server running 5.1.6 and AIX 4.3.3. I have a flat file and I run an SQL to query the TSM database for a specific node's archive and redirect output to a file. I've read up on the Administrator's Reference quide and see that I can use the

Re: SQL and delimiting fields

2005-08-04 Thread Prather, Wanda
Of Richard Mochnaczewski Sent: Thursday, August 04, 2005 10:18 AM To: ADSM-L@VM.MARIST.EDU Subject: SQL and delimiting fields Hi *, I need to audit some backups we have on our TSM server running 5.1.6 and AIX 4.3.3. I have a flat file and I run an SQL to query the TSM database for a specific node's

Re: SQL and delimiting fields

2005-08-04 Thread Gerald Michalak
basically it's a startup option to the dsmadmc command.. i.e. dsmadmc -comma selct xxx flatfile Gerald Michalak 630-691-4819 pager 800-759-8352 # 1076423 AIX - Certified Support Technician ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/04/2005 09:18:23 AM: Hi *, I need

Re: SQL and delimiting fields

2005-08-04 Thread Prather, Wanda
Mochnaczewski Sent: Thursday, August 04, 2005 10:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: SQL and delimiting fields Thanks Wanda and Gerald. Worked like a charm. Where did you find this info ? Rich -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Prather