ADSM-L

Re: SQL and delimiting fields

2005-08-04 10:25:03
Subject: Re: SQL and delimiting fields
From: Gerald Michalak <gmichala AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 4 Aug 2005 09:24:45 -0500
basically it's a startup option to the dsmadmc command.. i.e.

dsmadmc -comma "selct xxxxxxxxxxx  > flatfile "

Gerald Michalak
630-691-4819
pager 800-759-8352 # 1076423
AIX - Certified Support Technician


"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/04/2005
09:18:23 AM:

> 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

<Prev in Thread] Current Thread [Next in Thread>