Archives of the TeradataForum

Message Posted: Tue, 21 Jan 2003 @ 13:38:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

All,

If I run the following query:

 Select  '' (char(24)) as Cst_Cb_Cd,
  '' (char(60)) as Cst_Cb_Nm,
  rcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  rcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  rcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  rcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  rcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  rcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFRE2IBET.t_dim_ret_cst rcst

 Union

 Select  vcst.Cst_Cb_Cd (char(24)) as Cst_Cb_Cd,
  vcst.Cst_Cb_Nm (char(60)) as Cst_Cb_Nm,
  vcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  vcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  vcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  vcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  vcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  vcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFVO4IBET.t_dim_vol_cst vcst

I get Error 6706 'The string contains an untranslatable character.'

However, if I switch the Union around:

 Select  vcst.Cst_Cb_Cd (char(24)) as Cst_Cb_Cd,
  vcst.Cst_Cb_Nm (char(60)) as Cst_Cb_Nm,
  vcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  vcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  vcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  vcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  vcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  vcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFVO4IBET.t_dim_vol_cst vcst

 Union

 Select  '' (char(24)) as Cst_Cb_Cd,
  '' (char(60)) as Cst_Cb_Nm,
  rcst.Cst_C2_Cd (char(12)) as Cst_C2_Cd,
  rcst.Cst_C2_Nm (char(60)) as Cst_C2_Nm,
  rcst.Cst_C1_Cd (char(12)) as Cst_C1_Cd,
  rcst.Cst_C1_Nm (char(60)) as Cst_C1_Nm,
  rcst.Cst_Tc_Cd (char(10)) as Cst_Tc_Cd,
  rcst.Cst_Tc_Nm (char(60)) as Cst_Tc_Nm
 From INFRE2IBET.t_dim_ret_cst rcst

I do not get the error.

I've narrowed the problem down to the Cst_Cb_Cd Column in the INFVO4IBET.T_DIM_VOL_CST table. This column is defined as:

'CST_CB_CD VARCHAR(24) CHARACTER SET LATIN CASESPECIFIC NOT NULL'

I ran the Translate_Chk function on Cst_Cb_Cd Using Latin_To_Unicode and Unicode_to_Latin, and I didn't get any errors. I'm completely baffled. Has anyone seen this problem before?

Thanks,

Clay

	<Prev	Next>		<<First	<Prev	Next>	Last>>