MVSFORUMS.com

[Jai]

Hi Friends,

Please let me know how to resolve S04E Abend.

While inserting into Global Temporary Table, I am getting this error
I am selecting one more Global Temporary table inside while inserting the values in this Global Temporary table.
I heard that it can be due to pool allocation problem also.

Please let me know the possible solutions.

Thanks & Regards,
Jai
_________________
Have a Great Day.
Thanks & Regards,
Jai

[Bithead]

Please include SQLCode and Reason Code.

[Jai]

Hi Bithead,

Please find the details in systsprt:

DSN ENDED DUE TO ERROR+
SYSTEM ABEND CODE 04E REASON CODE 00E70005

Please find the details in sysout:

CEE3250C The system or user abend S04E R=00E70005 was issued.
From compile unit UPDTB2 at entry point UPDTB2 at statement 1760 at compile unit offset +00002312 at address 3EA6ADF2.
<> LEAID ENTERED (LEVEL 09/02/1999 AT 08.41)
<> LEAID ABENDAID DD ALLOCATED BY CWBMAKDD DYNALLOC RC =00000

In the line 1760 , I am inserting into one GTT(Global Temporary Table)
EXEC SQL
INSERT INTO SESSION.GTT3
(SELECT CAP_SE_NO FROM SESSION.GTT1
UNION
SELECT DISTINCT(CAP_SE_NO)
FROM SE_DETAIL
WHERE CAP_SE_NO <> '0000000000'
AND SKI_RT_LVL_CD = 'S' AND SE_HIER_CD = 'S'
)
END-EXEC
PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
CALL 'DSNHLI' USING SQL-PLIST13

and 1760 line is
CALL 'DSNHLI' USING SQL-PLIST13

and PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
CALL 'DSNHLI' USING SQL-PLIST13 is not in the program as you know.

GTTs are already declared.


Thanks in advance.
_________________
Have a Great Day.
Thanks & Regards,
Jai

[kolusu]

Jai,

Make sure that you have authority to load the GTT. Also I would like to check the space parameters for the GTT. Make sure that GTT is defined large enough to hold the no: of rows you are trying to insert.

Check this link for a detailed explanation of 00E70005 reason code

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/4.22.2?SHELF=&DT=20010718150520

Hope this helps...

cheers

kolusu