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 |