I have to drop tables looking at commentstring of the table. If the commentstring is not correct, I need to send an email out with the tablename.
Can someone help me with this error handling part?
You should be able to do that in UNIX script. Fetch the DDL from dbc tables and export them in some text file and then do the text parsing and take the actions accordingly.
I have done the text parsing using the otranslate. I am inserting all tables which need to be dropped in DRP_tables. If the commenstring is not correct , then I need the insert to throw an error with the tablename and send an email out. My issue is how do we throw an error at a particular record when the commentstring is not correct. I need to send the tablename in error in an email.
Any ideas on how to handle this?
Assuming you have all the error-tables in the Drp_Tables table .... you can export it as a text file and using an OS based script .... shell script .... you can send that list as an email.