ADSM-L

Using TSM OBDC Driver with Excel

2001-05-17 11:49:07
Subject: Using TSM OBDC Driver with Excel
From: "Short, Anne" <anne.short AT LMCO DOT COM>
Date: Thu, 17 May 2001 11:47:10 -0400
Has anyone seen this problem and know how to overcome it?

Using the TSM OBDC Drivers with Excel to import information regarding the
admin schedules into a spreadsheet, the STARTTIME column always shows up
with all zeros (00:00:00) for the time.  If I issue the very same select
statement from either the DSMADMC command line, or via a macro running in
the background, the STARTTIME column shows the correct times in HH:MM:SS
format.

In trying to schedule the million housekeeping chores that need to get done
in one 24-hour period, the start times are very important to us.  And having
it put in a spreadsheet automatically, as opposed to a flat file created by
the macro, or massaging the flat file by hand into a spreadsheet, is very
much preferred.

Anne Short
Lockheed Martin Enterprise Information Systems
Gaithersburg, Maryland
301-240-6184
CODA/I Storage Management
<Prev in Thread] Current Thread [Next in Thread>
  • Using TSM OBDC Driver with Excel, Short, Anne <=