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