ADSM-L

Re: Format of output file using select statements

2003-01-07 10:40:06
Subject: Re: Format of output file using select statements
From: Andy Carlson <andyc AT ANDYC.CARENET DOT ORG>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 7 Jan 2003 09:35:55 -0600
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
>