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:[EMAIL PROTECTED]]On Behalf Of > Andy Carlson > Sent: Tuesday, January 07, 2003 10:36 AM > To: [EMAIL PROTECTED] > 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 > > >