Extending DSNTIAR

Joe Luthman

Extending DSNTIAR
DSNTIAR is a nice start for post-processing of SQLCODE message text. But I would like to extend its functionality for some SQLCODES, to help the user more quickly determine how to fix the problem.
Ex. for -532, I would like to display ALL the first-level child rows of the one parent table that is experiencing the referential integrity error.
Ex 2. -805 SQLCODE actually includes the SQL for five types of errors that may have occurred. I'd like to execute those for which I have the information available, and place the output into a DSN of my choosing.
Ex 3. For -911 and -913, simply send alert messages to 3 of our staff who may then be able to avoid prolonged outages due to locking problems.

Please advise as to how best to extend DSNTIAR functionality, whether by invoking another program to do what I want, which in turn calls DSNTIAR, or by following DSNTIAR with the code that I need.


Joe Luthman
DBA Information Technology Services
Phone: (419)372-7750 260 Hayes Hall
FAX: (419)372-7723 Bowling Green State University
E-Mail: [login to unmask email] Bowling Green, OH 43403