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
 

 

Sql code -804

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

New User


Joined: 01 Mar 2007
Posts: 52
Location: chennai

PostPosted: Wed Dec 12, 2007 11:00 am    Post subject: Sql code -804
Reply with quote

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

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Wed Dec 12, 2007 11:06 am    Post subject:
Reply with quote

Selva,

Check the prev topic -

http://www.ibmmainframes.com/viewtopic.php?t=25217&highlight=804
Back to top
View user's profile Send private message
Selva-kumar

New User


Joined: 01 Mar 2007
Posts: 52
Location: chennai

PostPosted: Wed Dec 12, 2007 2:34 pm    Post subject:
Reply with quote

Hi,

I chacked the forum that you have mentioned. But still ic ouldn't able to resolve that problem.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Wed Dec 12, 2007 3:02 pm    Post subject:
Reply with quote

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

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Dec 12, 2007 5:49 pm    Post subject: Reply to: Sql code -804
Reply with quote

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
View user's profile Send private message
Selva-kumar

New User


Joined: 01 Mar 2007
Posts: 52
Location: chennai

PostPosted: Wed Dec 12, 2007 6:07 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 12, 2007 11:22 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Wed Dec 12, 2007 11:53 pm    Post subject:
Reply with quote

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
View user's profile Send private message
inamadugu
Warnings : 1

New User


Joined: 23 Aug 2007
Posts: 18
Location: Delhi

PostPosted: Thu Dec 13, 2007 9:55 am    Post subject: Reply to: Sql code -804
Reply with quote

Selva,
see this link
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 Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


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