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
 

 

SQLCode -804, REASON 14, SQLSTATE = 07002,

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

New User


Joined: 09 May 2005
Posts: 51
Location: Singapore

PostPosted: Thu Jul 13, 2006 4:39 pm    Post subject: SQLCode -804, REASON 14, SQLSTATE = 07002,
Reply with quote

Hi,

I am getting the following error message when i try to insert a record (Which is the first sql statement). The same program is calling some common programs whose db2 statements are successful.
Code:
 DSNT408I SQLCODE = -804, ERROR:  AN ERROR WAS FOUND IN THE APPLICATION PROGRAM
          INPUT PARAMETERS FOR THE SQL STATEMENT, REASON 07                   
 DSNT418I SQLSTATE   = 07002 SQLSTATE RETURN CODE                             
 DSNT415I SQLERRP    = DSNXECP SQL PROCEDURE DETECTING ERROR                   
 DSNT416I SQLERRD    = -301  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION         
 DSNT416I SQLERRD    = X'FFFFFED3'  X'00000000'  X'00000000'  X'FFFFFFFF'     
          X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION   


I tried to comment the insert statement, and the same result for the next stmt also (Select statement).

This program is running in CICSPLEX environment.

I am using static SQL. Please advice.

Thanks.
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Thu Jul 13, 2006 4:45 pm    Post subject:
Reply with quote

Hi,

Description of the Error: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.

User response: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.
Back to top
View user's profile Send private message
kvivek

New User


Joined: 09 May 2005
Posts: 51
Location: Singapore

PostPosted: Fri Jul 14, 2006 5:58 pm    Post subject:
Reply with quote

Thanks Guptae.

But I have already looked into the error assist.. This maynot be helpful for me..

I hope everyone looks for expert's solution/clarification only after their effort to solve the issue. I also tried to solve this issue as much as possible but could not.

I tried to reset SQLN and SQLDABC but got the same error -804 with different response code 14.

Expert's please advice.

Thanks,
Vivek
Back to top
View user's profile Send private message
samitcmathur

New User


Joined: 05 Feb 2006
Posts: 4

PostPosted: Fri Feb 22, 2008 7:37 pm    Post subject:
Reply with quote

i got error similar to that
SQLCODE : -000000804
SQLCAID : SQLCA
SQLCABC : 000000136
SQLERRML : 2
SQLERRMC : 06
SQLERRP : DSNXECP
SQLERRD(1): -209
SQLERRD(2): 0
SQLERRD(3): 0
SQLERRD(4): -1
SQLERRD(5): 0
SQLCAID : SQLCA
SQLCABC : 000000136
SQLERRML : 2
SQLERRMC : 06
SQLERRP : DSNXECP
SQLERRD(1): -209
SQLERRD(2): 0
SQLERRD(3): 0
SQLERRD(4): -1
SQLERRD(5): 0
SQLERRD(6): 0
SQLWARN :
SQLEXT : 07002
can you assist please
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Sat Feb 23, 2008 6:59 am    Post subject:
Reply with quote

you have either modified the pre-compiler generated CALLs to DSNLI or have used an definition of the sqlca that does not match your db2 version. Reseting SQLCA fields is useless because they are not used by db2 as input - they are output fields to db2.

are you running dynamic sql?
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 DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm


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