Christian Demnitz <[EMAIL PROTECTED]> 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
