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???
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.