| View previous topic :: View next topic |
| Author |
Message |
navhin
Beginner
Joined: 26 Mar 2007
Posts: 20
Topics: 7
Location: india
|
 Posted: Sat Oct 20, 2007 4:32 am Post subject: causes of SQL code -804 |
 |
|
hi,
i have an issue while running a SQL in COBOL.
the SQL returns the following with an SQL code -804.
could neone help on this.
please reply if you need nemore info to help me out.
thanks
SQLCAID : SQLCA
SQLCABC : 0000000136
SQLCODE : 000000080M
SQLERRM : :06
SQLERRP : DSNXECP
SQLERRD(1) : 000000020R
SQLERRD(2) : 0000000000
SQLERRD(3) : 0000000000
SQLERRD(4) : 000000000J
SQLERRD(5) : 0000000236
SQLERRD(6) : 0000000000
SQLWARN :
SQLEXT : 07002
_________________
navhin |
|
| Back to top |
|
 |
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Sat Oct 20, 2007 6:56 am Post subject: |
|
|
Have you used the IBM LookAt Site?
The info there should help you resolve your problem.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
vkphani
Intermediate
Joined: 05 Sep 2003
Posts: 483
Topics: 48
|
| Posted: Mon Oct 22, 2007 12:36 am Post subject: |
|
|
navhin,
post your sql and the entire error message displayed. |
|
| Back to top |
|
|
vivek1983
Intermediate
Joined: 20 Apr 2006
Posts: 222
Topics: 24
|
| Posted: Tue Oct 23, 2007 5:05 am Post subject: |
|
|
navhin,
The reason code as per you post is - 6.
The reason for this is : "The SQLDA, which is created by the application program, has an invalid
data type or data length. "
As indicated by phani, any help in this regard can be provided if you can post the actual SQL and the error messages that is associated with that.
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay) |
|
| Back to top |
|
|
navhin
Beginner
Joined: 26 Mar 2007
Posts: 20
Topics: 7
Location: india
|
| Posted: Tue Oct 23, 2007 11:44 pm Post subject: |
|
|
hi,
thanks a lot for your response.
the sql is a simple select query with a single field in the where clause.
the only point is that the no of times the SQL called in the prog is very high ( around 400 thousand times)
@vivek,
how can i validate wheher the SQLDA has an invalid data type or length.
please specify what error msgss would you require to see the problem clearly.
_________________
navhin |
|
| Back to top |
|
|
vivek1983
Intermediate
Joined: 20 Apr 2006
Posts: 222
Topics: 24
|
| Posted: Wed Oct 24, 2007 2:33 am Post subject: |
|
|
navhin,
| Quote: |
the sql is a simple select query with a single field in the where clause.
the only point is that the no of times the SQL called in the prog is very high ( around 400 thousand times)
|
Please confirm whether you are using declaring any cursor and fetching using that.
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay) |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Wed Oct 24, 2007 3:11 am Post subject: |
|
|
navhin,
| Quote: |
the sql is a simple select query with a single field in the where clause.
the only point is that the no of times the SQL called in the prog is very high ( around 400 thousand times)
|
This forum is not like a bar where you can go and bs the troops. No sql is simple, if you are having problems. you are assuming that it is simple.
there is no reason for us to guess.
tell us about the table being accessed. explain the column types involved in the sql.
by the way, something does not ring true. why would anyone design a program to perform 400k db2 calls? What is the purpose of the program?
if you don't want to give us any info, i am more than happy to continue writing critical posts.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
vkphani
Intermediate
Joined: 05 Sep 2003
Posts: 483
Topics: 48
|
| Posted: Wed Oct 24, 2007 3:15 am Post subject: |
|
|
navhin,
No one here would be able to help you out until and unless you provide your SQL and the error messages displayed. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
