I created a stored procedure as below
CREATE PROCEDURE devbidta.POC_ENROL9(IN compid INT)
DYNAMIC RESULT SETS 1
MODIFIES SQL DATA
DECLARE c1 CURSOR WITH RETURN TO CLIENT FOR
SELECT LEAD_NUMBER,MAX(ENROLLMENT_FLAG) AS ENROLLMENT_FLAG,
MIN(COLLECTOR_TRAIL_SEQ) AS CODE_POSITION FROM UATBIDTA.F_LEAD
WHERE RECORD_TYPE = ' ' AND COLLECTOR_TRAIL = ' '
AND COLLECTOR_COMPONENT_ID = compid
OPEN c1 ;
I used the commmand below to call the procedure:
CALL PGM(DEVBIDTA/POC_ENROL7) PARM(1)
I got the error below:
Message . . . . : Application error. MCH3601 unmonitored by POC_ENROL7 at
statement 0000000009, instruction X'0000'.
Cause . . . . . : The application ended abnormally because an exception
occurred and was not handled. The name of the program to which the
unhandled exception is sent is POC_ENROL7 POC_ENROL7 main. The program was
stopped at the high-level language statement number(s) 0000000009 at the
time the message was sent. If more than one statement number is shown, the
program is an optimized ILE program. Optimization does not allow a single
statement number to be determined. If *N is shown as a value, it means the
real value was not available.
Recovery . . . : See the low level messages previously listed to locate the
cause of the exception. Correct any errors, and then try the request again.
Kindly help me to figure out what could be the error
March 16, 2009 9:13 AM
March 17, 2009 1:39 PM