× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.