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: Murali Kumar <mkumar at nih dot gov>
Subject: Re: Query
Date: Sep 25 2000 2:09PM

Amit Agarwal wrote:

> Dear all,
>
> 1. If I execute a query like "select * from..." and would like to
> store the number of rows affected in a variable, how could I go about
> doing that.
>

The #rows affected is available through the system variable @@rowcount

>
> 2. If I execute a stored proc like "exec sp_helptext ...." from
> syberl, how can i capture the output to a flat file.
>
> Any help would be greatly appreciated.
>
> Regards.
>
> --------------------------------------------------------------------
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance
> upon, this information by persons or entities other than the
> intended recipient is prohibited. If you received this in error,
> please contact the sender and delete the material from any
> computer.
> --------------------------------------------------------------------