java - Calling a RPGIV function from SQL stored proc on DB2 -


hi im trying call rpgiv function 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 test in sql running: 

run ven60115.testjcall1(char(20), char(20))

the console returnes following message:

ven60115.testjcall1 - run started. data returned in result sets limited first 0 rows. data returned in result set columns limited first 100 bytes or characters. ven60115.testjcall1 - calling stored procedure.

but job hangs... please me.. or tell me i'm doing wrong?

i have decided call rpg functions using ibm java api's instead of using stored proc's sql.


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more