Hi Steve,

How about the client options -dataonly=yes  and -commadelimited or
-tabdelimited ?

You lose the headers and the formatting and get only the data you need.

See also:
http://www-01.ibm.com/support/docview.wss?uid=swg21143748

http://publib.boulder.ibm.com/infocenter/tsminfo/v6r2/index.jsp?topic=/com.ibm.itsm.srv.ref.doc/r_cmdline_adclient_options.html


Marcel


2011/3/9 Steve Harris <steve AT stevenharris DOT info>

> 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
>



--
Kind Regards, Groetje,

Marcel Anthonijsz