Allows a CLI application
to set the client user ID (accounting user ID) that is sent to a database
through DB2 Connect™ or DB2® database products. Applications
that do not specify the client user ID by default can use this keyword
to provide this information.
- db2cli.ini keyword syntax:
- ClientUserID = userid
- Default setting:
- None
- Applicable when:
- Connected to a database using DB2
Connect or DB2 for Linux, UNIX, and Windows
- Equivalent environment or connection attribute:
- SQL_ATTR_INFO_USERID
- Usage notes:
- Do not confuse the client user ID with the authentication user
ID. The client user ID is for identification purposes only and is
not used for any authorization.
Note the following conditions:
- Some servers might not be able to handle the entire length of
the value and might truncate it.
- DB2 for z/OS® and OS/390® servers support a length
of up to 16 characters.
- In DB2 Version
9.7 Fix Pack 6 and later, CLI applications
can set the ClientUserID keyword on DB2 for i V6R1
and later servers. DB2 for i servers
support a length of up to 255 characters.
- This user ID is not to be confused with the authentication user
ID. This user ID is for identification purposes only and is not used
for any authorization.
- To ensure that the data is converted correctly when transmitted
to a host system, use only the characters A - Z and 0 - 9 and the
underscore (_) or period (.).