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: sysprocesses columns
Date: Sep 23 2003 5:11PM

On Tue, 2003-09-23 at 08:21, Michael Burstin wrote:
> On Tue, Sep 23, 2003 at 11:09:10AM -0400, Sabherwal, Balvinder (MBS) wrote:
> > Group,
> > 
> > Any ideas of how you can populate the info into the clientapplname,
> > clienthostname, clientname columns in the sysprocesses table in master
> > database from perl scripts using syb-perl?
> > 
> 
> Well, right from the Sybperl manual, you get $appname and Sybase
> attribute CS_HOSTNAME.  Not sure about clientname, unless it is one of
> the attributes listed there:

CS_HOSTNAME is a different attribute. The clientXXX attributes are new
in 12.5 (I think), and are settable in SQL. I don't *think* that there
are corresponding API level attributes that can be set (though maybe I
should actually open the manual and look this up :-)

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler@peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html