Hi Richard,

The ODBC driver is really just a modified admin client that passes SELECT
statements from an application to the server, then passes the results from
the server back to the application. Thus the view of the TSM database is
the same whether you issue the SELECT via the ODBC driver or the admin
interface.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Richard Sims <rbs AT BU DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/22/2003 14:01
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: select query question



>Neat. ... I wonder where that information is stored?  Even the GUI has to
>get it from somewhere :)

Why, it's right there in the TSM db!  ;-)  We can't see it via Select
because that's a "fake" view of the database, revealing only a subset of
what's there, as the server administrator - by role definition - is not
to be concerned with such details.

I haven't used ODBC: is it the case that its view is likewise limited?

  Richard Sims, BU