I have looked at MyODBC, and confess I do not yet understand all of it,
but it looks like it needs a "driver" for a database. Does it have a
TSM Database driver? I could not fine one. Thanks.
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, Bill Boyer wrote:
> 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
> >
>
|
