Problem:

How can I enter a username greater than 8 characters with IBM UDB?

Resolution:

IBM DB2 UDB limits you to 8 character logon id's - see:

http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.uprun.doc/doc/r0006867.htm

USER authorization-name/host-variable

Identifies the user ID trying to connect to the application server. If a host-variable is specified, it must be a character string variable with a length attribute that is not greater than 8, and it must not include an indicator variable. The user ID that is contained within the host-variable must be left justified and must not be delimited by quotation marks.

USING password/host-variable

Identifies the password of the user ID trying to connect to the application server. The password or host-variable can be up to 14 bytes long. If a host variable is specified, it must be a character string variable with a length attribute not greater than 14, and it must not include an indicator variable.