DBD::Sybase and extended sysprocesses columns

"Matthew Persico" <[email protected]> Mon, 26 Mar 2007 12:36:04 -0400
Newsgroups gmane.comp.lang.perl.modules.dbi.sybase.devel,gmane.comp.lang.perl.modules.dbi.sybase
Message-ID <[email protected]>
In Sybase 12.5 (don't know about earlier versions) there are three
columns in sysprocesses:

 clientname         varchar  30 NULL  NULL     1 NULL   NULL   NULL     0
 clienthostname   varchar  30 NULL  NULL     1 NULL   NULL   NULL     0
 clientapplname   varchar  30 NULL  NULL     1 NULL   NULL   NULL
                                 0

that are much longer than the "normally" used ones for this info:
 hostname          char   10 NULL  NULL     0 NULL    NULL NULL 0
 program_name   char   16 NULL  NULL     0 NULL    NULL NULL 0

Any chance that we can fill in the longer columns with DBD::Sybase?
I've checked my sysprocesses table and it looks like NONE of the
various clients we use around here fill those fields. DBD::Sybase
would be a good start.

--
Matthew O. Persico