Troubleshooting character sets for Teradata data sources

When you set the TERADATA_CHARSET environment variable for a Teradata data source, you might encounter errors if the correct character set is not specified.

Symptom

If the correct character set is not specified for the Teradata data source, you will encounter the following error:

SQL 1822N Unexpected error code "227" 
received from data source "<string>". Associated text and 
tokens are "MTDP: EM_CHARNAME(227): invalid character set 
name specif". SQLSTATE=560BD

Cause

The character set that is specified in the TERADATA_CHARSET environment variable is incorrect.

Resolving the problem

Verify that the correct character set is installed and specified on the Teradata server and in the db2dj.ini file.