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: 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 
proceed.

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
-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@mbay.net       -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com
Sybase on Linux mailing list: ase-linux-list@isug.com