I've got the setting up of db2dsdriver.cfg sorted I believe (you
this with db2cli.exe).
What I can't find is any scripted way of adding / removing entries
db2cli.ini using the tools available with the Data Server Driver
(no DB2 CLP for example).
What I've not worked out
On 12 October 2017 at 07:41, Ludovic Janssens
<[login to unmask email]> wrote:
> Hi Phil,
> Normally, you should be able to select the driver parameters
> Windows ODBC admin panel. Make sure you have the correct one
(32 or 64bit).
> If I remember well, you can edit the DSN and then click to
> properties. You should get the extensive list.
> db2cli.ini doesn't work in all circumstances. You'll probably
have to look
> into the usage of the Db2dsdriver.cfg file; see https://www.ibm.com/
> Along with the db2dsdriver.cfg there is an xsd that can help
you to work
> upon the parameters.
> If you work with the parameters always check there exact
meaning on the
> correct knowledge center reference, because similar parameters
> different meanings when working with CLI, ADO.NET or
> Best regards,
> *Ludovic Janssens*
> Senior Consultant
> [login to unmask email]
> Mobile +32 492 25 10 73 <+32%20492%2025%2010%2073>
> [image: Twitter] https://twitter.com/ae_nv
> *ae *nv/sa n architects for business & ict n
> Interleuvenlaan 27b
> Researchpark Haasrode 1250, BE-3001 Heverlee
> Tel +32 16 39 30 60 <+32%2016%2039%2030%2060>, Fax +32
16 39 30 70
> <+32%2016%2039%2030%2070>, BTW BE0466550303
> [image: AE] http://www.ae.be/ae-email-banner-redirect
> *From:* Philip Nelson <[login to unmask email]>
> *Sent:* Wednesday, October 11, 2017 3:46:24 PM
> *To:* [login to unmask email]
> *Subject:* [DB2-L] - Setting Up ODBC Connections to Mainframe
> Server Driver Package Using db2cli
> I'm looking at setting up configurations to DB2 for z/OS from
the IBM Data
> Server Driver package. This is the client version which
doesn't have CLP,
> and so configuration is done with the db2cli command.
> I can set up connections and DSNs that appear in the ODBC
> (and in Excel).
> But since we are going to DB2 for z/OS, we used to set up
> restrict the amount of data being returned and limit (for
> table list to an individual database and / or table
> Looking at an export from an old client it looks like it has
> parameters set -
> In a DB area there is a "DBName" parameter. And in the ODBC
> is SchemaList parameter.
> Looking at the db2cli command, I can see that you can specifiy
> parameters option on writecfg, and I've found that with this
you can add
> <parameter> sections uder your <dsn>.
> I added the parameter "DBName" but it doesn't seem to filter
> at all as far as I can see.
> And I think the SchemaList has to go into the db2cli.ini file
? But I
> can't find any way of setting this up apart from a manual edit
on this type
> of client (on a regular client you'd use a "db2 update cli
cfg" but on the
> Data Server Driver package you don't have the DB2 CLP.
> Can anyone give guidance on -
> 1) How to set up an ODBC DSN using db2cli which will only show
> tables for one database and / or table qualifier on DB2 for
> 2) If needed, how to configure the db2cli.ini without just
> editing it ?
> -----End Original Message-----
> *AE-Disclaimer: Dit bericht is vertrouwelijk en exclusief
bestemd voor de
> geadresseerde ervan. Behoudens andersluidende expliciete
> publicatie, gebruik of verspreiding ervan niet toegelaten.
> afzender onmiddellijk te verwittigen in geval van foutieve
> ontvangst en verwijder het bericht. Visies en opinies
uitgedrukt in dit
> bericht zijn persoonlijk van de afzender tenzij aangegeven als
> AE of verbonden ondernemingen. This communication is intended
> addressee only and is privileged and confidential. Any
> disclosure, copying, distribution or use is prohibited. If you
> received this communication in error, please notify the sender
> and destroy the original communication. Views and opinions are
those of the
> sender unless clearly stated as being those of AE NV, its
> and/or associated companies. *
> -----End Original Message-----