By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Action with System Error Messages

P: n/a
I have a procedure that appends a flatfile daily into a table. In
most cases the procedure works as expected, but periodically, the
mainframe generated flatfile is corrupted and it stops the process in
its tracks with the ugly error message: "You tried to assign the Null
value to a variable that is not a variant data type." I tried to trap
that error message unsuccessfully, but what triggers it is the append
process itself when it hits the corruption. So it never gets to my
error routine.

What I would like to do is have it simultaneously execute at least a
Net Send message to specific DBAs when I get that message. I know
that I can use Shell("Net Send UserMachine Message Text") but I have
no clew on how to trigger this action when I get the error. Any ideas


Bob Bollinger
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.