Open command Computername

Author: roger.wallin@abilita.fi (rogerw)

Hi,

has someone been able to set the odbc-connection WSID from Uniface.
In other programming languages it's usually possible to set the WSID when initiating the connection "object". I suppose that this could be compared to what's done using "open" in Uniface.
If the WSID isn't set from the client-application the Computername is used. This is seen as the hostname in eg. Sql-Server sysprocesses-table/view (not sure about the table-name), which is usually seen by executing eg. sp_who.

SPID ECID  STATUS   LOGINAME         HOSTNAME               BLK   DBNAME  CMD   REQ_ID
55       0        SLEEP   APPLOWNER      SHAREDMACHINE    0       APPLDB    wait      0
56       0        SLEEP   APPLOWNER      SHAREDMACHINE    0      APPLDB     wait      0


Suppose that the computername is "SHAREDMACHINE", that is what is seen by eg. sp_who. We would like to change this to "Roger on SHAREDMACHINE", Roger being taken from a variable/table known by the client-session.

Is this a wish-candidate, or can it already be done in some way?

Regards RogerW.