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