Motivation Have you ever received an error message that left you scratching your head? Of course you have. Matter of fact I for one cannot recall any software product that ever outright impressed me with the quality of their error messages. DB2's messages, overall tend not to be too bad compared to what I have seen with competitors when it comes down to regular SQL. But things get really interesting when you add SQL PL (or PL/SQL) to the mix. "My" product OpenPages is chock full of tens of thousands of lines of PL/SQL and recently...
[More]
Tags:
source
error
message
line
number
sqlstate
sqlca
origin
sql
sqlcode
runtime
X
Interesting SQL solutions for DB2 LUW as well as hints on how to move Oracle applications to DB2
