Author: email@example.com (rogerw)
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?