Dave,
For point 3, you need to modify the connection string for your JDBC driver.
Here is mine, where I also use . instead of /
jdbc:as400://pli00001;binary=true;naming=sql
the "naming=sql" part gives you . instead of /
HTH,
Peter Colpaert
Software Engineer - PLM Development Team
Philips Consumer Luminaires
Tel: (+32) 3/459 13 17
Fax: (+32) 3/450 74 33
Address: Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Email: Peter.Colpaert@xxxxxxxxxxx
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave
Sent: woensdag 9 mei 2012 13:30
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: [WDSCI-L] Using quantum db
Hi all,
I'm trying to make the switch to QUANTUM DB but having some difficulties. I have a whole load of *.SQL files that I store my frequently or more complicated queries in. I'd like to be able to do the following, which is no problem with the ibm sql editor :
1 : open a *.sql file with a double click instead of right click then choose Quantum at the bottom of the list.
2 : have the sql file open within the quantum db perspective.
3 : be able to use the '.' instead of the '/' to qualify table names.
4 : be able to use the eclipse keyboard keys to edit ( alt + down to move lines, etc) - can't even click right and select copy/paste.
Merci, y'all!
--
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.
________________________________
The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.
midrange.com
