View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 06:17 PM
hatfieldrc@gmail.com
 
Posts: n/a
Default disjoin on size of host_name()

ASE 12.0.3.4
Solaris 7

When I log into my databases via SQL Advantage, I have the option to
specify a value for 'Client Host Name' which I can subsequently query
in a SQL Advantage statement: SELECT host_name(). This function
returns up to 30 characters of the value supplied in 'Client Host
Name'.

When I query master..sysprocesses however, I only see 10 of the 30
characters. How can I specify a 20+ character Client Host Name that I
can subsequently see in its entirety via SQL Central or via a query of
master..sysprocesses??

TIA,
Chris Hatfield
Falls Church, VA
US of A

Reply With Quote