Re: Calling a stored procedure that exists on the As/400 from PHP

[Gqcy <gmufasa01@xxxxxxxxx>]

CRPence wrote:
 i.e. time would be better spent actually examining the what
> & why of any difficulties in using the ODBC with stored procedures.
>
> Regards, Chuck



Thanks Chuck...

here is where I get stuck:

how my procedure is created:
CREATE PROCEDURE   XXX111
	(IN  PARM1  CHAR(15),
	INOUT PARM2 CHAR(30))
EXTERNAL NAME  GEMLIB.XXX111
LANGUAGE RPGLE  ;

My PHP:

<? $Item = '30019590       ' ;
   $Desc = '                        ' ;
   $con = as400connect();
   $sqlqte = "CALL GEMLIB.XXX111('". $Item . "''" . $Desc. "') ";
   SResultq = odbc_exec($con, $sqlqte) or die ("db Query Error");
   echo 'SResultq = ' . $SResultq   ;
   echo 'Description: ' . $Desc  ;
    ?>

My RPGLE program:
FXXXL01    IF   E           k disk 

FQSYSPRT   O    F  132        printer 

 ** 

C     *ENTRY        PLIST 

C                   Parm                    inprod           15 

C                   Parm                    outdesc          30 

 ** 

C     inprod        CHAIN(e)  XXXL01 

C                   if        %found(XXXL01) 

C                   Eval      outdesc = XDESC 

C                   EndIF 

C                   Except    detail 

C                   Eval      *inLR = *on 

 ** 

oQSYSPRT   E            Detail      1 

o                       INPROD           +0001 

o                       OutDesc          +0001 



RESULTS:
My program gets called.   INPROD = '30019590'.
HOWEVER I get a PARM error, OUTDESC is NOT ADDRESSABLE.