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.simon AT FREE DOT 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.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é.

-- 

 Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622