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 wsaccess dot com>
Subject: RE: capturing sp_showplan output
Date: Sep 4 2001 6:02PM

> From: Jason_Price@cargill.com [mailto:Jason_Price@cargill.com]

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

Surprised you haven't gotten a response yet. You can retrieve the
sp_showplan output via your message handler (you do have one, don't you?
:-).

Steve
--
Steve Wechsler/Application Manager/Wall St. Access
Steven.Wechsler@wsaccess.com
"There is no reason anyone would want a computer in their home." 
-- Ken Olson, president, chairman and founder of DEC, 1977