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.

For most tables, a TSM SELECT works fine.  For the occupancy table,
"q occupancy" may be preferable to a SELECT, because some character
fields may be truncated by a SELECT due to the way the column is defined.

Steve Bacher
Draper Laboratory
Cambridge, MA, US
seb AT draper DOT com