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: Jason_Price at cargill dot com
Subject: capturing sp_showplan output
Date: Sep 4 2001 5:21PM

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?

Thanks.

Jason Price
Jason_Price@cargill.com
LYNX Database Support
Cargill Grain Division 
(952)984-1311