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