---Does anyone know whether monitoring for SQL0000, SQ20000, and SQ30000 will trap all of the SQLxxxx, SQ2xxxx, and SQ3xxxx errors?

Yes, that is how MONMSG works in CL programs.


--Will SQ*nnnn messages that are really *not* errors be flagged as well?
--- Dan

You shouldn't have to worry about message ids that are "not" errors.

The command only sends failure messages as Escape, which is all you can monitor for with a MONMSG.
A failure message is one with a Negative SQL Code.

Chris Hiebert
Senior Programmer/Analyst
Disclaimer: Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.


This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.