RE: Fwd: Execute Failed with Stored Procedure Call -- RPG400-L

Actually, I meant to ask if this belongs in the RPG forum. I said C because
that's what I'm working with currently.... Sadly, that's my best excuse.
If it does, it does. I just wanted to make sure you are talking to the right
audience.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Where a calculator on the ENIAC is equpped with 18,000 vaccuum tubes and
weighs 30 tons, computers in the future may have only 1,000 vaccuum tubes
and perhaps weigh 1 1/2 tons."
-- Popular Mechanics, March 1949

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.

--
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.