Re: Calling i Function from PHP

I don't have all the context but it looks like you are using an SQL function like a PHP function, which are 2 different things. The syntax of your SQL select statement at the bottom of your message looks correct.

Thanks,
Todd


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Tuesday, February 05, 2013 9:06 AM
To: Web Enabling the AS400 / iSeries
Subject: [WEB400] Calling i Function from PHP

I thought I could do this in PHP:

$Wk_Error = MSP_ValidateStoreFN($Wk_Store);

Where MSP_ValidateStoreFN is a function on the i. I'm getting this message in php.log:

"PHP Fatal error: Call to undefined function MSP_ValidateStoreFN() in ..."

I created the function with the Create Function SQL statement on the i.

Is this syntax not available, and I need to use db2_exec or db2_execute?

I believe I could use this function like this:
"Select * from StrMaster where MSP_ValidateStoreFN($Wk_Store) = 'Y';"
Is that correct?

Thanks!

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.