RE: [WDSCI-L] Quantum DB perspective

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

Try

jdbc:as400://10.1.0.2;libraries=DIJKBV,*LIBL;naming=system

cheers
Colin.W

http://as400blog.blogspot.com
 

-----Original Message-----
From: Dijk, Bas v [mailto:bvdijk@xxxxxxxxx] 
Sent: 08 April 2005 10:19
To: Websphere Development Studio Client for iSeries
Subject: RE: [WDSCI-L] Quantum DB perspective


Thanks for the info.

I tried the following url's:

jdbc:as400://10.1.0.2 libraries=DIJKBV
jdbc:as400://10.1.0.2 libraries = DIJKBV
jdbc:as400://10.1.0.2 libraries=*LIBL
jdbc:as400://10.1.0.2 libraries = *LIBL

My driver:
AS/400 Toolbox for Java JDBC Driver com.ibm.as400.access.AS400JDBCDriver
5.0
C:\Program Files\IBM\Client Access\jt400\lib\jt400.jar
DB2 for AS400

But when I try: 

SELECT * FROM SOMETBL (instead of SELECT * FROM DIJKBV.SOMETABLE) 

it won't work.

Are there any documents on the possible syntax on the URL line? Or is my
mistake so obvious that someone could point it out to me?


-----Oorspronkelijk bericht-----
Van: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
Namens Colin Williams
Verzonden: vrijdag 8 april 2005 10:44
Aan: 'Websphere Development Studio Client for iSeries'
Onderwerp: RE: [WDSCI-L] Quantum DB perspective


- Where can I setup my Quantum DB so that it uses a standard bookmark
(library) or my library list (so I can omit the bookmarkname in my
statements)?

*Setup your library list on the driver url: libraries = mylib1,mylib2,*libl

- Can I setup the returned list with info in a way like 'strsql' does (so it
only shows the first page and shows the next 'page' when I start to scroll)?

*It does only show the first page, you need to click the down arrow to see
the next page, but I think the page length is quite long

- Are there any analysing options like in the iSeries Navigator?

*Quantum DB is basically a gui for the java database driver, if you want any
more functionality than that you will probably need to contact the
developers, or code something up yourself

Another happy QuantumDB user.

Cheers
Colin.W

http://as400blog.blogspot.com
This e-mail has been sent by a company of Bertram Group Ltd, whose
registered office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and
may contain privileged or confidential information.  If you are not the
intended recipient, any disclosure, copying, distribution or any action
taken or omitted to be taken in reliance on it, is prohibited and may be
unlawful.  If you believe that you have received this email in error, please
contact the sender immediately. Opinions, conclusions and statements of
intent in this e-mail are those of the sender and will not bind a Bertram
Group Ltd company unless confirmed in writing by a director independently of
this message. 
Although we have taken steps to ensure that this email and any attachments
are free from any virus, we advise that in keeping with good computing
practice the recipient should ensure they are actually virus free.

--
This is the Websphere Development Studio Client for 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.
******************************************************************
Deze e-mail is gecontroleerd op virussen.
Aan de inhoud van dit bericht kunnen geen rechten ontleend worden.
******************************************************************

-- 
This is the Websphere Development Studio Client for 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.
This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is 1 Broadland Business Park, Norwich, NR7 0WF. 
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately. Opinions, conclusions and statements of intent in this 
e-mail are those of the sender and will not bind a Bertram Group Ltd company 
unless confirmed in writing by a director independently of this message. 
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.