|
View previous topic :: :: View next topic
|
| Author |
Message |
Ajay Baghel
Active User
Joined: 25 Apr 2007
Posts: 205
Location: Bangalore
|
|
|
|
Hi Frens,
We are getting the S04E reason code 00E7000C abend in a cobol-ims-db2 program. The abend aid listing shows the abend place as:
| Code: |
EXEC SQL
UPDATE
TABEL1
SET COL1 = :COL1 ,
COL2 = :COL2
WHERE
COL3 = :COL3
AND COL4 = :COL4
AND COL5 = :COL5
END-EXEC |
An invalid address supplied by the application program was found.
Probable cause:
Parameter list for hte sql statement has been overlaid. The SQL-AVAR-LIST or SQL-pvar-list contains an invalid address to locate the data variable.
In the DB2 option in abend, i see the data type as invalid for a host variable.
field address(in hexa) data-type value
for field1
some_proper_address DEC(5,236) some_proper_val
for field2
some_proper_address
some_proper_val
Any pointers how to resolve it?
Thanks,
Ajay
|
|
| Back to top |
|
 |
|
|
rexzone1
New User
Joined: 16 Dec 2006
Posts: 14
Location: Halifax, Canada
|
|
|
|
Hi Ajay,
I am also facing the same issue as you had reported.
I hope you would have got some resolution for this.
If you got through this, can you please share that with me.
Regards,
Ravi |
|
| Back to top |
|
|
vijikesavan
Active User
Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA
|
|
|
|
I got this error sometime back and I re-compiled program through endevor. It got fixed.
Please check your link libraries. Just a suggestion. |
|
| Back to top |
|
|
rexzone1
New User
Joined: 16 Dec 2006
Posts: 14
Location: Halifax, Canada
|
|
|
|
| I have re-compiled the program again but still it is getting the problem. I don't have a SYSUDUMP to be compared with SQLCA as well. |
|
| Back to top |
|
|
Ajay Baghel
Active User
Joined: 25 Apr 2007
Posts: 205
Location: Bangalore
|
|
|
|
Hi vijikesavan,
Can you please pin point exactly where the problem was in your case.
For ex did you add any file, or was any link library or somethng else changed by the programmer during the recompiling.
I mean i want to know what changes were made during the recompilation.
Please elaborate a bit about your resolution.
Thanks,
Ajay |
|
| Back to top |
|
|
|
