|
View previous topic :: View next topic
|
| Author |
Message |
kvivek
New User
.jpg)
Joined: 09 May 2005
Posts: 51
Location: Singapore
|
|
|
|
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 |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
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 |
|
|
kvivek
New User
Joined: 09 May 2005
Posts: 51
Location: Singapore
|
|
|
|
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 |
|
|
samitcmathur
New User
Joined: 05 Feb 2006
Posts: 4
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
|
|
