Anyone know what causes this error. Returns about 261,000 records, then fails.
Error Message: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQ20226 - The maximum number of stacked diagnostics areas has been exceeded.Thanks. I have been able to resolve this. The problem was being caused by a caclulation in the SQL statement that caused a "divide-by-zero" in a number of cases (this is a large file with about 20 joins). By inserting a CASE statement to handle the zeros, I was able to fix the view.
Evidently there is a limit on how many of this type of error SQL can handle.I have no idea... Is there a specific code being thrown by your SQL statement itself?Not sure either, It's in the book asSQLSTATE=0Z001 SQLCODE=-20226 but that doesn't seem to give any thing more than the error does.
Have a look here (http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/sqlp/rbafysqldiag.htm) it seems to be talking around the area.#If you have any other info about this subject , Please add it free.# |
|
Posted by jack on January 8th, 2009
Filed in iraquideaths.com edit
