Thanks Wanda and Gerald. Worked like a charm. Where did you find this info ?

Rich

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Prather, Wanda
Sent: Thursday, August 04, 2005 10:22 AM
To: ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Mochnaczewski
Sent: Thursday, August 04, 2005 10:18 AM
To: ADSM-L AT VM.MARIST DOT 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