Re: Quantum DB

["Brian Johnson" <brian.johnson.mn@xxxxxxxxx>]

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.