View previous topic :: View next topic
|
Author |
Message |
av_sukumar
New User
Joined: 12 Oct 2004 Posts: 6
|
|
|
|
--------------------------------------------------------------------------------
Hi,
When I am testing one db2+cobol program, the job was ended with db2 error. I checked the sqlcode which was -180. I know that this is the problem with invalid date,time or timestamp value or syntax. I did recheck all the variable lengths and values. Everything looks correct only.
But, I am not at all understanding why the problem reoccuring.
Could any one of you give me an idea, any thing else to be checked???
Thanks in advance.. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
If you post your sql code that is failing, the variable definitions for all of the fields, and display the values for each field before executing the problem sql statement, we may be able to offer suggestions.
From what you have posted, the only advice can be check again. . .
If you post the info, we may be able to see something. |
|
Back to top |
|
|
prasadvrk
Active User
Joined: 31 May 2006 Posts: 200 Location: Netherlands
|
|
|
|
Quote: |
I know that this is the problem with invalid date,time or timestamp value or syntax. I did recheck all the variable lengths and values. |
unless you post your code we can not offer much help. The value may not be wrong but syntax is. |
|
Back to top |
|
|
|