Up Prev Next
From: Michael Peppler <mpeppler at mbay dot net>
Subject: Extracting a Sybase SP with DBI or sybperl?
Date: Jan 12 1999 11:58PM
>>>>> "Bill" == Bill Middleton writes:
Bill> I'd like to extract a certain stored procedure periodically and
Bill> compare it to the version on disk, to see if anyone has changed
Bill> it w/o checking it out. Is there a way to extract a given SP
Bill> (in a sybase server), using DBI or sybperl?
The text of teh stored proc is stored in syscomments. So it's pretty
trivial to extract the sproc text. There are even two example scripts
in the DBD::Sybase distribution that should give you an idea of how to
In the eg/ directory you have dbschema.pl which extracts the entire
schema for a database, and Show.cgi which is a CGI script that shows
the text of a stored proc with the keywords highlighted.
Michael Peppler -||- Data Migrations Inc.
email@example.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: firstname.lastname@example.org