RE: calling store procedure

["Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx>]

I just got done teaching a vendor how to do this who is trying to sell me
his product that is suppose to do the same thing :-)
Check out the below email. . .  HTH, Aaron Bartell




Here is how you make the final call.  Note that you need to have a reference
to a file for a SELECT statement to work.  I just created a PF with one
field.  You can do it from RPG using the SET SQL command but that wouldn't
make sense to do it form there.

SELECT IWAY_TEST1( char(123)) FROM albartell/junkpf

Here is the code necessary to interface with the below sub procedure.
CREATE FUNCTION QGPL.IWAY_TEST1 ( 
        FLD1 CHAR(30) ) 
        RETURNS CHAR(30)   
        LANGUAGE RPGLE 
        SPECIFIC QGPL.IWAY_TEST1 
        DETERMINISTIC 
        NO SQL 
        RETURNS NULL ON NULL INPUT 
        NO EXTERNAL ACTION 
        EXTERNAL NAME 'EBTOOLS/IWAYSV(TEST1)' 
        PARAMETER STYLE GENERAL ;



 
//--------------------------------------------------------------------------
------------------
      // @Author - Aaron Bartell
      // @Description - This is a simple sub proc that receives in a
alpha(30) and outputs a
      //                alpha(30) field.
      // @Usage -
 
//--------------------------------------------------------------------------
------------------
     P test1           B                   Export
     D test1           PI            30A
     D  pInput                       30A   Const
      /Free

       Return pInput;

      /End-Free
     P test1           E