× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I've been trying to get the debugger up and running per section 3.10.1
of http://www.redbooks.ibm.com/abstracts/sg246503.html.



I have been successful at stepping through stored procedures with no
parameters, however when calling a stored proc with an IN parm of
Integer type, the debugger throws an exception on the first line of the
stored procedure:



"Exception: Pointer not set for location referenced"



This is how I call the stored procedure:



CALL PGM(AMFLIB/TEST_DBG_2) PARM(13000)



Also, how would I call a stored procedure with IN and OUT parms from the
console?



Procedure:

CREATE PROCEDURE AMFLIB . TEST_DBG ( IN CUSTNUMBER INTEGER ) RESULT SETS
1 LANGUAGE SQL SPECIFIC TEST_DBG_2 READS SQL DA

SOURCE

BEGIN

DECLARE TOTALACTIVITY DECIMAL ( 8 , 3 );

SELECT SUM ( JQGLVA ) INTO TOTALACTIVITY FROM AMFLIB . MTHACTE WHERE
CUSNO = CUSTNUMBER;

END;


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.