Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

S04E R=00E7000C

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
dharani.nagarajan

New User


Joined: 11 Nov 2010
Posts: 21
Location: India

PostPosted: Tue Jun 14, 2011 2:56 pm    Post subject: S04E R=00E7000C
Reply with quote

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
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Tue Jun 14, 2011 3:02 pm    Post subject: Reply to: S04E R=00E7000C
Reply with quote

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

a naive search with 00E7000C would have taken You here
http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z9.doc.codes/src/tpc/00e7000c.htm
Back to top
View user's profile Send private message
dharani.nagarajan

New User


Joined: 11 Nov 2010
Posts: 21
Location: India

PostPosted: Tue Jun 14, 2011 3:36 pm    Post subject: Reply to: S04E R=00E7000C
Reply with quote

Enrico,

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

Thanks,
Dharani
Back to top
View user's profile Send private message
sunojsm
Warnings : 1

New User


Joined: 21 Jun 2004
Posts: 33
Location: Andorra

PostPosted: Wed Jun 15, 2011 2:56 pm    Post subject: Reply to: S04E R=00E7000C
Reply with quote

Hi,

Is there any duplicate utility id created ?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Wed Jun 15, 2011 3:23 pm    Post subject: Reply to: S04E R=00E7000C
Reply with quote

Quote:
Is there any duplicate utility id created ?


why do You feel that the reasons described int the manual link provided
might be related to a duplicate utilid ???
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts User Abend S04E in cobol DB2 program knilesh23 COBOL Programming 5 Fri Jan 18, 2013 6:32 pm
No new posts REORG S04E Reason=00E4D5D2 Daniel Prosser DB2 7 Wed Apr 11, 2012 2:32 pm
No new posts S04E Error Encountered gaurav.rajvanshi DB2 16 Wed Jul 13, 2011 12:26 pm
No new posts S04E Abend Bill O'Boyle COBOL Programming 2 Fri Apr 09, 2010 4:41 pm
No new posts S04e abend Gay251319 IMS DB/DC 5 Thu Nov 12, 2009 10:16 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us