S04E R=00E7000C

dharani.nagarajan · New User Joined: 11 Nov 2010 Posts: 21 Location: India

Hi,

I am getting the below error while executing the stored procedure TESTPGM

CEE3250C The system or user abend S04E R=00E7000C was issued.

From compile unit TESTPGM at entry point TESTPGM at compile unit offset +00000F66 at entry offset +00000F66 at address
2EC98F66.

TESTPGM is the stored procedure here. The SQL query in the stored procedure where the abend occurs is
EXEC SQL
SELECT DISTINCT ID_TYP
INTO :HIST-ID-TYP
FROM HIST_TAB
WHERE ID_TYP = :WS-ID-TYP
END-EXEC.

Can you please help me in this.. This query works fine in SPUFI..

Thanks for the help.

Thanks,
Dharani

enrico-sorichetti · Posted: Tue Jun 14, 2011 3:02 pm

what happened when You researched/googled for the abend and the reason code ?

a naive search with 00E7000C would have taken You here
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z9.doc.codes/src/tpc/00e7000c.htm

dharani.nagarajan · New User Joined: 11 Nov 2010 Posts: 21 Location: India

Enrico,

Thanks for the link..
I was trying google with 'S04E R=00E7000C' and didnt get any good solution.

Thanks,
Dharani

sunojsm · New User Joined: 21 Jun 2004 Posts: 33 Location: Andorra

Hi,

Is there any duplicate utility id created ?

enrico-sorichetti · Posted: Wed Jun 15, 2011 3:23 pm