Topic
No replies
juchin
juchin
8 Posts
ACCEPTED ANSWER

Pinned topic subroutine from stored procedure

‏2013-11-15T15:56:52Z |

We want to call subroutine from stored procedure on DB2/LINUX V10.1.  Now stored procedure is failed when stored procedure calls subroutine.

We develop some subroutines (with SQL or without SQL) which are called by stored procedure.  All stored procedures and subroutines are written by MF/COBOL. Our strategy is that subroutines are dynamically loaded from stored procedure. We test all subroutines from COBOL main programs (non stored procedure) and these subroutines run normally.

We implement DB2 settings.

-  export  COBDIR/COBPATH/LD_LIBRARY_PATH  (DB2 instance user)

-  db2set DB2LIBPATH=$LD_LIBRARY_PATH

-  db2set DB2ENVLIST="COBDIR LD_LIBRARY_PATH"

 

But we cannot call subroutines from stored procedure.

Can you suggest any advice?

Thank you for your advice in advance.

 

Handa