ADSM-L

Re: Format of output file using select statements

2003-01-07 14:21:18
Subject: Re: Format of output file using select statements
From: Bill Boyer <bill.boyer AT VERIZON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 7 Jan 2003 14:17:44 -0500
It's caled MyODBC. see
http://www.mysql.com/search/index.php?q=myodbc&from=%2Findex.html

Bill Boyer
DSS, Inc.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Andy Carlson
Sent: Tuesday, January 07, 2003 10:36 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Format of output file using select statements


Is there an ODBC driver for Unix and Mysql?


Andy Carlson                                    |\      _,,,---,,_
Senior Technical Specialist               ZZZzz /,`.-'`'    -.  ;-;;,_
BJC Health Care                                |,4-  ) )-,_. ,\ (  `'-'
St. Louis, Missouri                           '---''(_/--'  `-'\_)
Cat Pics: http://andyc.dyndns.org/animal.html


On Tue, 7 Jan 2003, Peter Bjoern wrote:

> >People here have suggested various ingenious combinations of
> >tail/awk/grep to strip out the garbage, and they work fairly well.
> >But that seems a little Rube Goldbergish, and I'm a little worried
> >that it might break if something in the output changes.  I think I
> >already know the answer (No), but does anybody know of a way to keep
> >that stuff from appearing in the output, instead of finding it and
> >throwing it away afterwards?
>
>
> You may want to consider using the ODBC approach and retrieve the
> information in
> a well defined format.
>
> I most cases you'll be able to extract the same information from the
> database via the
> ODBC interface as you can with the dsmadmc select command.
>
> You will, of course, have to use a platform where there is an ODBC driver
> for
> the TSM database available.
>
> Regards
>
> Peter
>