Hm. I've been around since V2 - I think I probably learned about it first on this list! But it's in the Admin Ref, chapter 3, under the subheading "Using Administrative Client Options".
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] 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 PROTECTED] Behalf Of Prather, Wanda Sent: Thursday, August 04, 2005 10:22 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL and delimiting fields -commadelimited is a parm you can use on the dsmadmc command when you invoke it from a host command line: dsmadmc -id=adminid -password=adminpassword -commadelimited "select * from whatever">outputfile -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL 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 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 -COMMADELIMITED parameter to output the SQL output. How do I incorporate this parameter as I can't find any reference to how to actually use it, only that it can be used. Rich