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 peppler dot org>
Subject: Re: capturing sp_showplan output
Date: Sep 4 2001 11:49PM

Jason_Price@cargill.com writes:
 > I'm trying to figure out how to capture the sp_showplan output from 
 > within sybperl.  The only thing I seem to be able to capture is a 
 > return value.  Using my usual methods to verify output 
 > (ct_sql("sp_showplan , null, null, null", sub {print @_})), I 
 > still just get the return value of 0.
 > 
 > Obviously, showplan does not print to STDOUT or STDERR.  Does anyone 
 > know of a way I can capture this output?

As Steven said - sp_showplan (and a lot of other utility calls in
Sybase) return their information via the server callback handler (or
the message handler, for DBlibrary).

You need to create an ad-hoc server callback handler that captures and
prints out the appropriate information.

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com