RE: Calling a DB procedure from another DB

Ali,
To work with output parameters, you must define a stored procedure based
on the CL/RPG/COBOL program. 

For example,

 CREATE PROCEDURE ALI/DOIT(    
    in action      char(10 )         
  , out msg      varchar(100)         
                              )      
                                     
  DETERMINISTIC                      
  NO SQL                             
  EXTERNAL NAME   ALI/DOITPGM     
  PARAMETER STYLE GENERAL            

Shalom Carmel
-------------
www.venera.com - Exposing iSeries insecurity

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of 
> ali.juzer@xxxxxxxxx
> Sent: Wednesday, May 18, 2005 10:00 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: RE: Calling a DB procedure from another DB
> 
> 
> 
> Thanks Charles!
> 
> I am now able to call CL, COBOL, RPG programs using the
> DBMS_HS_PASSTHROUGH.EXECUTE_NON-QUERY function. But now, 
> another problem
> has popped up:
> 
> It works fine if my AS/400 program does not have any parameters or has
> only input parameters. But if my program has any output 
> parameters, then
> the call fails. I am using the proper sequence (open_cursor,
> parse,bind_variable etc)
> 
> Any pointers/idea on why is this happening?
> 
> Regards,
> Ali Asgar Juzer
>