Re: Fwd: Execute Failed with Stored Procedure Call

[Michael Ryan <michaelrtr@xxxxxxxxx>]

Hi Dennis -

I don't think there's any C involved...just RPG, PHP and the stored
procedure in the middle. Are you referring to the stored procedure being
converted to C or something?

On Thu, Dec 2, 2010 at 9:06 AM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

> Does this belong in the C forum?
>
> Dennis Lovelady
> http://www.linkedin.com/in/dennislovelady
> --
> "If you think education is expensive, try ignorance."
>        -- Derek Blok
>
>
>
> > I've tried using both System naming and SQL naming. I know have this as
> > my
> > connection command:
> >
> > $options = array('i5_naming'=>DB2_I5_NAMING_ON);
> > $conn = db2_connect($systemname, $username, $password, $options);
> >
> > I do see an error on the db2_prepare when I have the naming wrong...for
> > instance, it looks in the user's library when it's Sys naming, and it
> > can't
> > find the procedure there.
> >
> > I don't see an error on the db2_execute...at least I'm not seeing any
> > value
> > in db2_stmt_error(), though I do see the value in db2_stmt_errormsg().
> > Is
> > there another way that I can see errors?
> >
> > I'd like to look on the iSeries for an error message, but I'm not sure
> > where
> > to look.
> >
> > Thanks...
> >
> > - Michael
> >
> > On Wed, Dec 1, 2010 at 4:30 PM, Mark Murphy/STAR BASE Consulting Inc. <
> > mmurphy@xxxxxxxxxxxxxxx> wrote:
> >
> > > What's the error?  Are you using System naming or SQL naming?
> > >
> > > Mark Murphy
> > > STAR BASE Consulting, Inc.
> > > mmurphy@xxxxxxxxxxxxxxx
> > >
> > >
> > >
> > > From:   Michael Ryan <michaelrtr@xxxxxxxxx>
> > > To:     "RPG programming on the IBM i / System i" <rpg400-
> > l@xxxxxxxxxxxx>
> > > Date:   12/01/2010 02:01 PM
> > > Subject:        Fwd: Execute Failed with Stored Procedure Call
> > > Sent by:        rpg400-l-bounces@xxxxxxxxxxxx
> > >
> > >
> > >
> > > I've cross posted this since it's an RPG/stored procedure question.
> > >
> > > Thanks!
> > >
> > > ---------- Forwarded message ----------
> > > From: Michael Ryan <michaelrtr@xxxxxxxxx>
> > > Date: Wed, Dec 1, 2010 at 1:46 PM
> > > Subject: Execute Failed with Stored Procedure Call
> > > To: Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
> > >
> > >
> > > Hi folks -
> > >
> > > Could someone help me out with this? I'm trying to call a stored
> > procedure
> > > from my PHP script. Lots of help from lots of folks, and it's very
> > much
> > > appreciated. I've decided to use the MODS approach. I'm getting an
> > error
> > > on
> > > the db2_execute...here's a link to the PHP code:
> > > http://code.midrange.com/09a32d9a0e.html
> > >
> > > I know the connection is being made, and I know the db2_prepare is
> > > successful. I'm passing two parameters to the procedure and expecting
> > an
> > > array (MODS) back. Do I need to specify the array in the db2_prepare
> > > statement?
> > >
> > > Here's my CREATE PROCEDURE statement that I executed from STRSQL:
> > >
> > > CREATE PROCEDURE INVENTORY/SPR101R(IN pInVnda CHAR ( 5), IN pInMdl
> > > CHAR ( 20)) LANGUAGE RPGLE NOT DETERMINISTIC READS SQL DATA CALLED
> > > ON NULL INPUT EXTERNAL NAME 'NEWSYS/SPR101R' PARAMETER STYLE GENERAL
> > >
> > > Here's the salient part of my RPG code:
> > >
> > >            Exec SQL
> > >                Set Result Sets For Return To Client
> > >                  Array :ReturnDS For :WkRowcount Rows;
> > >
> > > This works when I call the procedure from iSeries Navigator.
> > >
> > > Thanks!
> > > --
> > >
> > > This is the RPG programming on the IBM i / System i (RPG400-L)
> > mailing
> > > list
> > > To post a message email: RPG400-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > > or email: RPG400-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/rpg400-l.
> > >
> > >
> > > --
> > > This is the RPG programming on the IBM i / System i (RPG400-L)
> > mailing list
> > > To post a message email: RPG400-L@xxxxxxxxxxxx
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > > or email: RPG400-L-request@xxxxxxxxxxxx
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/rpg400-l.
> > --
> > This is the RPG programming on the IBM i / System i (RPG400-L) mailing
> > list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.