If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Stored Procedure Problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-18-03, 17:05
tmacksam tmacksam is offline
Registered User
 
Join Date: Nov 2003
Posts: 18
Question Stored Procedure Problem

Here is my stored procedure:

CREATE PROCEDURE TESTF.MINBALANCE (
INOUT ITEM CHAR(15) ,
INOUT WAREHOUSE CHAR(2) ,
OUT AISTRQ DECIMAL(9, 2) ,
OUT AIPROM DECIMAL(9, 2) ,
OUT AIAVAIL DECIMAL(9, 2) ,
OUT AIMIN DECIMAL(9, 2) ,
OUT NEEDED DECIMAL(9, 2) ,
OUT AIMDTE DECIMAL(8, 0) ,
OUT AIPLNR CHAR(1) ,
OUT IDESC CHAR(30) ,
OUT LEAD INTEGER ,
OUT LOT DECIMAL(9, 2) ,
OUT ONORD DECIMAL(9, 2) ,
OUT NETREQ DECIMAL(9, 2) ,
OUT UNPLNDREQ DECIMAL(9, 2) )
LANGUAGE SQL
SPECIFIC TESTF.MINBALANCE
NOT DETERMINISTIC
READS SQL DATA
CALLED ON NULL INPUT

P1 : BEGIN -- Stored procedure calculates the Minimum Balance Inquiry by passing in an Item and Warehouse

BEGIN -- Select Main information from DAI, IIM, and IWI

SELECT DAI . AISTRQ , DAI . AIPROM , DAI . AIAVAIL , DAI . AIMIN , ( DAI . AIMIN - DAI . AIAVAIL ) NEEDED , DAI . AIMDTE , DAI . AIPLNR , IIM . IDESC , CASE WHEN IWI . WLEAD = 0 THEN COALESCE ( IIM . ILEAD , 0 ) ELSE IWI . WLEAD END "LEAD_TIME" , CASE WHEN IWI . WLOTS = 0 THEN COALESCE ( IIM . ILOTS , 0.00 ) ELSE IWI . WLOTS END "LOT_SIZE"
INTO AISTRQ , AIPROM , AIAVAIL , AIMIN , NEEDED , AIMDTE , AIPLNR , IDESC , LEAD , LOT
FROM TESTF . DAI DAI LEFT OUTER JOIN TESTF . IIM IIM ON DAI . AIPROD = IIM . IPROD INNER JOIN TESTF . IWI IWI ON DAI . AIPROD = IWI . WPROD AND DAI . AIWHS = IWI . WWHS
WHERE DAI . AIWHS = WAREHOUSE AND DAI . AIPROD = ITEM ;


-- Call stored procedure STPCALC to get on order, net required, and unplanned required quantities
call TESTF.STPCALC(ITEM,WAREHOUSE,ONORD,NETREQ,UNPLNDRE Q);

END ;

END P1

The stored procedure compiles just fine but when I go run the stored procedure I get an error: [CEE9901] Application error. MCH1202 unmonitored by MINBALANCE at statement 0000000065, instruction X'0000'

I do not understand this error. When I take out the portion where I am calling another stored procedure the stored procedure runs fine. I have used other stored procedures where I call a stored procedure within a stored procedure and it works fine.

Any help on this would be greatly appreciated!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On