Re: Using quantum db

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.

--
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.