SEO

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

master..sysprocesses.hostname has been defined as 'char(10)'; not much
chance of getting much more than 10 characters squeezed into that lil slot.

Looks like you're stuck with using the host_name() function (which does
appear to return up to 30 characters).

Probably wouldn't hurt to put in an enhancement request with Sybase to have
them extend master..sysprocesses.hostname out to a full 30 characters (or
more?).

hatfieldrc@gmail.com wrote:
> 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
>