Hi, yes, I found that webcast useful. And indeed, I would have loved to see the auditoccup table to be filled, unfortunately no. But I've at least managed to get the occup data I need.
Op 25 apr. 2014, om 13:37 heeft Erwann Simon <erwann.si...@free.fr> het volgende geschreven: > 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.p...@plcs.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é. -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622
