Parsing stored proc/sql code

"Wechsler, Steven" <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <E67053DABCCDF4428BB7974550E1108F010890E7@DIRECTEFFECT.mtvn.ad.viacom.com>
I've been asked to write a script to examine new stored procedures to see if
they do any writing (i.e. delete, insert, update) to the database, or,
recursively, if they call any stored procs that write to the database. I
can't just do a simple grep but also have to ignore comments and quoted
strings.

Before I embark on this task, I wonder if anyone's ever done anything like
this (even part of it); I'd hate to reinvent the wheel.

Thanks,

Steve
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.