Re: Quantum DB

[Jeff Young <cooljeff913@xxxxxxxxx>]

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.