Problem:

Problem: db2 8.1  stored procedure - compiling into dll and calling from java and gets error

1131n dari stored procedure process been terminated abnormally  38503

Resolution:

Resolution:

Make sure

Either add the Net Express executable directory (base\\bin ) to the PATH statement

or

copy the COBOL run-time .dll (cblrtss.dll if using single threaded run-time ) to the directory from where the stored procedure will be executed. You need to do this for DB2 to be able to execute a COBOL stored procedure.

Customer copied the cblrtss.dll into the sqllib\\function directory and that resolved the 1131 error

See on-line documentation for more information

Help > Contents >Programming > Database Access (folder)

    > Database Access Book > Part 3 DB2 > chapter 12 Stored Procedures

    > Db2 Stored Procedures > Working with Stored Procedures