SQL stored procedure on UDB 8.1.3 ....

From: Raquel (raquel_at_nospam.com)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 06:21:17 -0400

This is the first simple SQL PL stored procedure that I tried on UDB (UDB
PE on XP):

CREATE PROCEDURE SQLSP1
( IN PEMPNO CHAR(6)
, IN PRAISEPCT DEC(6,2)
)
LANGUAGE SQL
UPDATE DB2ADMIN.EMPLOYEE
SET SALARY = SALARY * (1 + PRAISEPCT/100)
WHERE EMPNO = PEMPNO;

While executing this statement, it fails:

SQL1131N DARI (Stored Procedure) process has been terminated abnormally.

Explanation:

The cause of this error may be:

o There was a coding error (e.g. segmentation violation) within the
DARI routine.
o The DARI process has been terminated by another process through the
use of a signal.

 User Response:

Reinitiate the DARI request after doing the following :

o Ensure that the DARI procedure is free from programming errors.

o Make sure that no user is sending a termination signal to the DARI
process.

 sqlcode : -1131

 sqlstate : 38503

I have no idea; does it have something to do with C compiler not properly
set up on my machine? How do I do that?

Thanks.
Raquel.