Hi, i'm getting this warning message in one ODBC reference:
TRANSLATION FROM CCSID 1252 TO 937 NOT DEFINED
any help will be appreciated.
thanks,
CCSID value
Moderators: chulett, rschirm, roy
ml,
the CCSID doesn't ring a bell, but the 1252 and 937 are codesets (1252 is Windows Latin codepages, and 937 is traditional Chinese).
Do you have NLS enabled in DataStage or in the database?
the CCSID doesn't ring a bell, but the 1252 and 937 are codesets (1252 is Windows Latin codepages, and 937 is traditional Chinese).
Do you have NLS enabled in DataStage or in the database?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
mat,
is this a problem with the table as a whole or with a specific value in a row? In the first case you will need to set the NLS for the job as a whole and in the latter it might mean that a character has shown up in the table which cannot be mapped into the target character set.
So, where and how does this error occur?
is this a problem with the table as a whole or with a specific value in a row? In the first case you will need to set the NLS for the job as a whole and in the latter it might mean that a character has shown up in the table which cannot be mapped into the target character set.
So, where and how does this error occur?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
This warning appear in a whole column mapped in a direct reference. I solve the problem when I put a hash file in the middle. But this is not the solution I want... any idea on how to solve this issue?
this is the detail:
warning message "TRANSLATION FROM CCSID 1252 TO 937 NOT DEFINED"
Where should be this translation defined?
thanks,
ps: another solution I found is change the code page in the database for this table, but again is not the best solution...
this is the detail:
Code: Select all
Reference (China code page CCSID 937)
|
Input value--->TRF--->Output value
(Latin CCSID)
Where should be this translation defined?
thanks,
ps: another solution I found is change the code page in the database for this table, but again is not the best solution...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: