sreda, 12. julij 2006

DB2 CLP error codes

Hmm.. Until yesterday I didn't know what DB2 CLP does not return only
0 = OK
1 = 0 rows
2 = warning
4 = SQL error
8 = system error
It also returns a combination of them, like 6 = 2 + 4, meaning that there was a warning and an error.
You can imagine how my eyes got bigger when I saw an errorCode of 6. :) I was quite embarrassed, since I've been working with DB2 for quite some time now.
I guess I should have read the manual :)))

Ni komentarjev: