Syntax for calling stored procedure

["Fleming, Greg \(ED\)" <GFLEMING@xxxxxxxxxxxxxxxxxxxx>]

I created a stored procedure from STRSQL like so:

CREATE PROCEDURE gnodgdf/getShortSKU(

OUT ShortSKU CHAR(7),                

IN Company CHAR(3),                  

IN SoldTo CHAR(9),                   

IN Item CHAR(12))                    

LANGUAGE RPGLE

SPECIFIC GNODGDF/ORDERAPI_getShortSKU                  

NOT DETERMINISTIC                                      

NO SQL                                                 

CALLED ON NULL INPUT                                   

EXTERNAL NAME 'GNODGDF/SORDERAPI(ORDERAPI_GetShortSKU)'

PARAMETER STYLE GENERAL    

 

I got the message indicating that it was successfully created. 

Now the question.  How do I call it ?  Can I test this interactively
from STRSQL or Iseries Navigator RUNSQL Scripts ? 

What's the correct syntax ? 

If not, what's the correct syntax using EXEC SQL in RPG (/Free) ? 

 

Thanks                                                   

 

Greg Fleming

Senior Programmer/Analyst

Everglades Direct, Inc.