DB2 Version 10.1 for Linux, UNIX, and Windows

DB2Connection.ClientWorkStation Property

Gets or sets the client workstation name string value.

Namespace:
IBM®.Data.DB2®
Assembly:
IBM.Data.DB2 (in IBM.Data.DB2.dll)

Syntax

[Visual Basic]
Public Property ClientWorkStation As String
[C#]
public string ClientWorkStation {get; set;}
[C++]
public: __property String* get_ClientWorkStation();
public: __property void set_ClientWorkStation(String*);
[JScript]
public function get ClientWorkStation() : String;
public function set ClientWorkStation(String);

Property value

The name of the client workstation that is sent to a database. In Version 9.7 Fix Pack 5 and earlier, the default value is an empty string ("").

If you do not specify the ClientWorkStation property, the default value that consists of the host name is used. If you do not configure the host name or you encounter an error during the host name retrieval, an empty string ("") value for the ClientWorkStation property is sent to the server.

Note the following conditions:
  • Some servers might not be able to handle the entire length of the value and might truncate it.
  • You must set the ClientWorkStation property before the start of a transaction. Changes to the ClientWorkStation property after the start of a transaction do not take effect until the start of the next transaction.
  • DB2 for z/OS® and OS/390® servers support a length of up to 18 characters.
  • CLI applications can set the ClientWorkStation property on DB2 for i V6R1 and later servers. DB2 for i servers support a length of up to 255 characters.
  • To ensure that the data is converted correctly when transmitted to DB2 for z/OS Version 9 and earlier, use only the characters A - Z and 0 - 9 and the underscore (_) or period (.).