SQL Error codes from UNIX box
Posted: Thu Jun 07, 2007 12:15 am
Hi,
I am trying to update a field with in the table with some where clause, when the where clause fails.....it gives me an return code of 1 which indicates failure.
If we look something of this sort from Mainframe point of view, we have some thing called as Communication area where in which we get the return code as +100 indicating that the is no record with the given where clause.
Do we have any thing of this sort while writing some script using the Unix box to get the actual SQL error codes rather then just 0 or 1.
If yes how can we achieve that.
Let me know if you need any further information to help you?
I am trying to update a field with in the table with some where clause, when the where clause fails.....it gives me an return code of 1 which indicates failure.
If we look something of this sort from Mainframe point of view, we have some thing called as Communication area where in which we get the return code as +100 indicating that the is no record with the given where clause.
Do we have any thing of this sort while writing some script using the Unix box to get the actual SQL error codes rather then just 0 or 1.
If yes how can we achieve that.
Let me know if you need any further information to help you?