Re: SQL naming + library list

[Charles Wilt <charles.wilt@xxxxxxxxx>]

The 7.1 manual shows Alias only good for tables or views...

Perhaps you're thinking of one of these
SET [CURRENT FUNCTION] PATH =
SET SCHEMA =
SET OPTION SQLPATH =

IIRC, both the schema and path can be specified on the
JDBC connection properties..

Charles



On Mon, Feb 11, 2013 at 8:55 AM, Allen, Todd
<Todd.Allen@xxxxxxxxxxxxxxxxx>wrote:

> The SPROC is called from a Java web app.  The call is currently qualified
> as library.sproc.  Leaving out the library defaults to the user profile
> name as the library.  That is the expected behavior.  However, I remember
> reading about a way around this by using an alias but cannot recall the
> details.
>
> Thanks.
>
>
> -----Original Message-----
> From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
> Behalf Of Richard Schoen
> Sent: Saturday, February 09, 2013 5:38 PM
> To: web400@xxxxxxxxxxxx
> Subject: Re: [WEB400] SQL naming + library list
>
> Hi Todd,
>
> Are you trying to call the SP from .Net, PHP , Java ?
>
> I would think as long as you set the default library list when connecting
> with the DB drivers, then you should be able to call a SP just be name.
>
> With SQL naming you can also qualify it with LIB.PROCNAME.
>
> Regards,
> Richard Schoen
> RJS Software Systems Inc.
> Where Information Meets Innovation
> Document Management, Workflow, Report Delivery, Forms and Business
> Intelligence
> Email: richard@xxxxxxxxxxxxxxx
> Web Site: http://www.rjssoftware.com
> Tel: (952) 736-5800
> Fax: (952) 736-5801
> Toll Free: (888) RJSSOFT
>
> ----------------------------------------------------------------------
>
> message: 1
> date: Fri, 8 Feb 2013 21:09:48 +0000
> from: "Allen, Todd" <Todd.Allen@xxxxxxxxxxxxxxxxx>
> subject: [WEB400] SQL naming + library list
>
> Is there any way to use SQL naming in an unqualified (no library) call to
> a stored procedure and have the library list used?  I seem to recall that
> an alias can be used to mimic the library list behavior when using SQL
> naming.
>
> I know system naming would be much easier but that is not an option at
> this time.
>
> Thanks,
> Todd Allen
> Estes Express Lines
> tallen@xxxxxxxxxxxxxxxxx<mailto:tallen@xxxxxxxxxxxxxxxxx>
>
>
> For More Than 80 Years-Delivering Solutions That Exceed Expectations.
>
> This communication and any transmitted documents are intended to be
> confidential. If there is a problem with this transmission, please contact
> the sender. If the reader of this message is not the intended recipient, or
> the employee or agent responsible to deliver it to the intended recipient,
> you are hereby notified that any dissemination, distribution or copying of
> this communication is strictly prohibited.
>
>
> --
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> list To post a message email: WEB400@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/web400.
>
> --
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
> list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.