Re: SQL and delimiting fields

2005-08-04 Thread Prather, Wanda
On Behalf Of Richard 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 PROTECTE

Re: SQL and delimiting fields

2005-08-04 Thread Richard Mochnaczewski
PROTECTED] On Behalf 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 d

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" wrote on 08/04/2005 09:18:23 AM: > Hi *, > > I need to audit som

Re: SQL and delimiting fields

2005-08-04 Thread Prather, Wanda
ED] On Behalf 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 f

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 -CO