|
View previous topic :: View next topic
|
| Author |
Message |
Selva-kumar
New User
Joined: 01 Mar 2007
Posts: 52
Location: chennai
|
|
|
|
HI,
When i'm running a cobol DB2 program, i'm getting sqlcode -804. The program was running fine for last two days. But today its showing me this error. Also, the problem is occurring always at the 5th record. Fourth and fifth record are having the same value. It's working for 4th rec but showing error for 5th rec. I checked the reason for 804 but i'm not clear how to resolve it. Please help me. |
|
| Back to top |
|
 |
murmohk1
Senior Member
.jpg)
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
| Back to top |
|
|
Selva-kumar
New User
Joined: 01 Mar 2007
Posts: 52
Location: chennai
|
|
|
|
Hi,
I chacked the forum that you have mentioned. But still ic ouldn't able to resolve that problem. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| most of the time I have found the cause of the -804 was due to erroreous overlaying of data by the module. Usually due to internal COBOL table manipulation or some idiot wrote code with reference modification. Anyway, check out what your code is doing to your working storage. |
|
| Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004
Posts: 70
|
|
|
|
Selva,
description of -804 is given below.
Reason: AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT
Description: The call parameter list or the SQLDA is invalid. One of the following conditions exist: * The call parameter list, which is created by the precompiler, may be invalid if the application programmer has modified the output of the precompiler, used a variable name beginning with 'SQL' in the application program, or overwritten the call parameter list in some other way. * The SQLDA, which is created by the application program, has an invalid length or may contain an invalid data type or data length.* The value of SQLDABC is not consistent with the value of SQLD.
Action Needed: Examine the application program for any of the errors noted under the explanation above. Note that, in general, the application programmer should not attempt to modify the output of the precompiler.
May be if you recompile the program, it will avoid getting -804.
Regards
Rags |
|
| Back to top |
|
|
Selva-kumar
New User
Joined: 01 Mar 2007
Posts: 52
Location: chennai
|
|
|
|
Hi rags,
The description that you have given for the sqlcode 804 is already available in the jobspool. I'm able to understand what is 804 abend. What i really need is the fix to 804 abend. My program is not abending bcos of any of the reasons mentioned above. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| The description that you have given for the sqlcode 804 is already available in the jobspool. I'm able to understand what is 804 abend. What i really need is the fix to 804 abend. My program is not abending bcos of any of the reasons mentioned above |
| Quote: |
| Reason: AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT |
I suspect the program is "abending" because of this "reason above".
How are we to help? You have not posted anything for us to work with. . .
What has changed since the last good run? What is special about the 4th or 5th row? Is this a production program that has been modified? Is this a program that is currently being developed (as opposed to existing production)?
The more info you provide, the more someone may be able to help. |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| Selva-kumar wrote: |
| My program is not abending bcos of any of the reasons mentioned above. |
If you are that sure of yourself why are asking us for help? |
|
| Back to top |
|
|
inamadugu
Warnings : 1
New User
Joined: 23 Aug 2007
Posts: 18
Location: Delhi
|
|
|
|
Selva,
see this link |
|
| Back to top |
|
|
|
|
