× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Jeff,

Try something like:

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

The libraries are separated by commas.

Douglas Belcher
KV Pharmaceutical
St Louis, MO
Opinions expressed are not necessarily those of my employer


-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jeff Young
Sent: Monday, June 11, 2007 8:17 AM
To: Websphere Development Studio Client for iSeries
Subject: Re: [WDSCI-L] Quantum DB

Brian,
I removed the exta apostrophe, but it still did not work.
The list of properites does need to be delimited by a semi colon.
I tried a comma, and instead of the message indicating *LIBL, it
indicated JYOUNG as the location it could not find the file.

Any suggestions would be appreciated.

Thanks,


Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions V5R2 IBM Certified Specialist- e(logo) server i5Series
Technical Solutions Designer V5R3 IBM Certified Specialist-
e(logo)server i5Series Technical Solutions Implementer V5R3









----- Original Message ----
From: Brian Johnson <brian.johnson.mn@xxxxxxxxx>
To: Websphere Development Studio Client for iSeries
<wdsci-l@xxxxxxxxxxxx>
Sent: Friday, June 8, 2007 6:07:45 PM
Subject: Re: [WDSCI-L] Quantum DB


You have an apostrophe between the last library name and the closing
quote.

Also, I wonder if the list of properties should be comma-delimited:

jdbc:as400://vai520;libraries="R37FDQA,R37FDQAF",naming=system




On 6/8/07, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

Brian,
I have the following specified in my connection
url: jdbc:as400://vai520;libraries="R37FDQA,R37FDQAF'";naming=system

When I execute the query Select * from vinitem, I get a message
indicating that file VINITEM is not found in *LIBL.

When I qualify the file to R37FDQAF, it works.

Is there a format error in my list of libraries in the connection url?

Thanks,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions
V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions

Designer V5R3 IBM Certified Specialist- e(logo)server i5Series
Technical Solutions Implementer V5R3









----- Original Message ----
From: Brian Johnson <brian.johnson.mn@xxxxxxxxx>
To: Websphere Development Studio Client for iSeries
<wdsci-l@xxxxxxxxxxxx>
Sent: Friday, June 8, 2007 5:36:51 PM
Subject: Re: [WDSCI-L] Quantum DB


Check out JDBC properties and JDBC URL syntax:

URL syntax:

"jdbc:as400://systemName/defaultSchema;listOfProperties"


More into at:


http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=
/rzahh/jdbcdrvr.htm







On 6/8/07, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

Is there any configuration item to set the default library list so
that
I
do not have to qualify my query?
My default user library list does not have the libraries I need to
search.

Thanks,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions
V5R2
IBM Certified Specialist- e(logo) server i5Series Technical
Solutions Designer V5R3 IBM Certified Specialist- e(logo)server
i5Series Technical Solutions Implementer V5R3





______________________________________________________________________
______________
Moody friends. Drama queens. Your life? Nope! - their life, your
story.
Play Sims Stories at Yahoo! Games.
http://sims.yahoo.com/
--
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.




--
Brian Johnson
brian.johnson.mn@xxxxxxxxx
--
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.




______________________________________________________________________
______________ Get the free Yahoo! toolbar and rest assured with the
added security of spyware protection.
http://new.toolbar.yahoo.com/toolbar/features/norton/index.php
--
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.




--
Brian Johnson
brian.johnson.mn@xxxxxxxxx
--
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.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.