Hello Remco,

I tried, but didn't succeed and gave up when I found that some views are empty 
or not updated (don't know if it's still true) or use IDs instead of names (you 
then need to do joints to see real names).

You may have a look to this webcast :

http://www-01.ibm.com/support/docview.wss?uid=swg27021413

On 24 avril 2014 13:12:50 CEST, Remco Post <r.post AT PLCS DOT NL> wrote:
>Hi all,
>
>I'm working on a simple excel for billing purposes (as a first step).
>I've installed the DB2 Data server driver ODBC (and CLI) package. And
>have managed to configure both a user DSN and a file DSN, but not a
>system DSN, which is what I prefer, because other people will have to
>be able to generate the monthly report as well. The file DSN is giving
>me headaches every time I try to refresh the table, for some reason ms
>query and/or excel think a sql server is a better solution than db2 and
>want to connect me to such a thing. The user dsn seems to work better
>(though I had to tweak it somewhat to make it work).
>
>Has anyone succeeded in creating a system DSN for a ODBC connection to
>the DB2 used by TSM and make it work?

-- 
Erwann SIMON
Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.