Search code examples
javasqldb2rpg

Calling a RPGIV function from SQL stored proc on DB2

Hi im trying to call a RPGIV function from a stored proc:

CREATE PROCEDURE "VEN60115"."TESTJCALL1" 
(IN ADUI CHAR(20),
OUT PRODOPIID1 CHAR(20))
DYNAMIC RESULT SETS 1 
LANGUAGE RPGLE 
READS SQL DATA 
EXTERNAL NAME 'VEN60115/TESTJV'
PARAMETER STYLE GENERAL ;

When I test this in SQL by running: 

Run VEN60115.TESTJCALL1(CHAR(20), CHAR(20))

The console returnes the following message:

VEN60115.TESTJCALL1 - Run started.
Data returned in result sets is limited to the first 0 rows.
Data returned in result set columns is limited to the first 100 bytes or characters.
VEN60115.TESTJCALL1 - Calling the stored procedure.

But the job hangs... Could anyone please help me.. or tell me what I'm doing wrong?

Solution

  • I have decided to call rpg functions using the IBM java api's instead of using Stored proc's from SQL.