--- Matthew Persico <[EMAIL PROTECTED]> wrote: > 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
Hi Matthew, These are set at the ASE server not at the client connection ct_connect() (v12.0 and higher). So.. it would be nice for Michael to add them as part of the standard 'after connect' processing but we do have a workaround until then. :) $dbh->do(...) ============== User settable process information The set command includes options that allow you to assign each client an individual name, host name, and application name. This is useful for differentiating among clients in a system where many clients connect to Adaptive Server using the same name, host name, or application name. The partial syntax for the set command is: set [clientname client_name | clienthostname host_name | clientapplname application_name] Where client_name is the name you are assigning the client, host_name is the name of the host from which the client is connecting, and application_name is the application that is connecting to Adaptive Server. These parameters are stored in the clientname, clienthostname, and clientapplname columns of the sysprocesses table. For more information, see Chapter 10, “Managing Adaptive Server Logins and Database Users” in the System Administration Guide. ============ Michael, could this go into the next version? jason Jason L. Froebe Help find a cure for breast cancer! Net proceeds benefit the Susan G. Komen Breast Cancer Foundation and the National Philanthropic Trust. Help by donating at http://www.the3day.org/chicago07/jfroebe - I'm walking 60 miles in 3 days in August 2007. (The day I return from TechWave is the first day of the Walk) WebBlog http://jfroebe.livejournal.com Tech log http://www.froebe.net/blog Froebe Fibers http://www.froebe-fibers.com
