Re: Fwd: Execute Failed with Stored Procedure Call

[Michael Ryan <michaelrtr@xxxxxxxxx>]

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.