On Mar 19, 2004, at 19:53, Stephen E. Bacher wrote:

Christian Demnitz <christian.demnitz AT sinius DOT com> wrote:

is there any way, to get data from tsmdatabase directly into a mysql
db?
like via odbc to ms access?

i want to generat a report with a mysql db!

I do this regularly, using the same technique you would use to load
data directly from TSM into an Excel spreadsheet:  use the
"-tabdelimited"
(under Unix, at least) argument on the dsmadmc line command and put
"> filename" on the end of the query or select command.  From there you
can do a 'load data infile "filename"' in MySQL.

and with a recent client you could also save yourself the trouble of
stripping headers and stuf by using -dataonly=y

--
Met vriendelijke groeten,

Remco Post

SARA - Reken- en Netwerkdiensten                      http://www.sara.nl
High Performance Computing  Tel. +31 20 592 8008    Fax. +31 20 668 3167

"I really didn't foresee the Internet. But then, neither did the
computer industry. Not that that tells us very much of course - the
computer industry didn't even foresee that the century was going
to end."                                       -- Douglas Adams