Below is what I use for a connection string: (names changed to protect the innocent)
jdbc:as400:server.company.com;prompt=false;translate binary=true;naming=system;date format=iso;libraries=LibNam1, LibNam1, LibNam1, LibNam1, LibNam1, LibNam1, LibNam1;
Using "libraries" allows me to use system naming and therefore a library list like concept in the connection. Which further allows us to not hardcode libraries in our SQLs.
I then have 3 different connections defined with different libraries for our development, test, and production servers.
Oh and I should mention that I use the Quantum plugin. So your mileage with what ever plug-in you are using may differ. :)
Thanks,
Scott J
-----Original Message-----
From: WDSCI-L [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Ken Killian
Sent: Friday, October 07, 2016 3:03 PM
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (wdsci-l@xxxxxxxxxxxx) <wdsci-l@xxxxxxxxxxxx>
Subject: [WDSCI-L] RDI 9.5.1 Connection for DB2
Hi,
I am using RDI 9.5.1, how do I modify the library List for my DB2 connection, which I use for testing Stored Procedures....
The Default Schema does not have my test library on the library List...
In Squirrel, I change my configuration for a default library List by having this as my connection String:
jdbc:as400://MyIBMi7.2box/MyLibrary...
On the Driver Properties the CONNECTION URL: is protected!
So, it seems to update when I update the host to this:
MyIBMi7.2box\myLibrary....
Which produces this Connection URL:
jdbc:as400:MyIBMi7.2box\mylibrary;prompt=false
But, then doing the Test Connection, it fails...
Anybody have an idea how to configure a DB2 Driver in the "Database Development" view for testing in a test library?
I had this working on some previous release, I am almost positive...
-Ken Killian-
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
midrange.com
