Teradata BTEQ logon with Latin Character SET

Connectivity

Teradata BTEQ logon with Latin Character SET

Hi All,

I am unable to set the Session to Latin.

I am using TD 14 & trying to logon from Unix terminal using below command:

bteq -c Latin1 .logon server/user,pwd

(Note: i am able to set the same for Acii which is default or utf8 using "bteq -c Ascii" or "bteq -c utf8)

I referred below links

http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/Interface_Tools/B035_2425_071A/24...

http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/International_Character_Set/B035_...

Tried using

LATIN1_0A/ LATIN1252_0A/ ASCII-LATIN/ iso8859-1 / L1 with "bteq -c " & none worked.

Also tried logging in using ASCII and then use

.SET SESSION CHARSET 'name'

In both the case, I am facing below error.

 *** CLI error: MTDP: EM_CHARNAME(227): invalid character set name specified.

 *** Return code from CLI is: 227

 *** CLI error: MTDP: EM_CHARNAME(227): invalid character set name specified.

 *** Return code from CLI is: 311

Can anyone tell me how to set my TD session to MS Latin1?

Thanks

Tags (1)

Accepted Solutions
Teradata Employee

Re: Teradata BTEQ logon with Latin Character SET

"latin1" is a server character set, not a client chacter set. You probably need to install the LATIN1_0A, or LATIN1252_0A, character sets. Follow the procedure in:

http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/International_Character_Set/B035_1125_111K/ch03.0...

Note that the DBS also needs to be restarted.

-Dave

1 ACCEPTED SOLUTION
1 REPLY
Teradata Employee

Re: Teradata BTEQ logon with Latin Character SET

"latin1" is a server character set, not a client chacter set. You probably need to install the LATIN1_0A, or LATIN1252_0A, character sets. Follow the procedure in:

http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/International_Character_Set/B035_1125_111K/ch03.0...

Note that the DBS also needs to be restarted.

-Dave