PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: "Wechsler, Steven" <Steven dot Wechsler at mtvstaff dot com>
Subject: Parsing stored proc/sql code
Date: Feb 25 2005 3:12PM

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