User executed a store procedure on Toad for DB2 v 4.7 and got empty result sets. However, on Quest Central for DB2 v 5.0 it returned data.
The procedure is designed to return a status of -1 if it detects abnormalities. In this case, an abnormality was detected.
See attachment with Toad and QCDB2.
STATUS:
Enhancement request ST 80224 has been submitted to Development for consideration in a future release of Toad for DB2.
WORKAROUND:
None
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center