Hi All I've inherited a Rube Goldberg reporting system where TSM queries are run against systems, and the results from all the TSM instances, then run through a very ugly rexx script to produce a consolidated csv file for each day. This is then further processed by some rather opaque VBA and the end result is a consolidated backup spreadsheet for each customer, for the whole month.
The issue I have is that with a 6.2.0.0 admin client (on windows) and a 5.5 server the TSM query output looks like... NODE_NAME STATUS RESULT SCH_DATE SCH_TIME ACT_DATE ACT_TIME -------------------------- ---------- ----------- ---------- -------- ---------- -------- ADCMOHTSM01-BA Completed 0 2011-03-09 20:00:00 2011-03-09 20:00:08 ARTHUR Completed 4 2011-03-10 00:30:00 2011-03-10 00:31:54 AT1RTJA Completed 0 2011-03-10 03:30:00 2011-03-10 03:30:39 But with the same admin client and a 6.2.2.0 server I get NODE_NAME STATUS RESULT SCH_DATE SCH_TIME ACT_DATE ACT_TIME ------------------ ------------------ ------------ ----------- --------- ----------- --------- KDCUNITSM00-BA Completed 0 2011-03-09 08:00:00 2011-03-09 08:00:04 KDCUNITSM00-BA Completed 0 2011-03-09 10:02:16 2011-03-09 10:05:39 KDCUNITSM00-BA Completed 0 2011-03-09 11:07:00 2011-03-09 11:07:02 I can cope with the column spacing being different, but the blank lines are throwing the rexx script into a tight loop. I've tried sqldisplaymode wide/narrow with no effect, and the problem persists if I drop the number of fields in the output, so its not that the line is just full enough to overflow. Any ideas on how to get around this? Thanks Steve Steven Harris TSM Admin Paraparaumu New Zealand
