I am wondering if anyone has come across this situation and if so any advice is appreciated.
Situation:
Datastagem: 7.5.1.A
Platform: Windows
Source: SQL server
Job:
ODBC ---> Transformer ---> Hash File
Recently I converted the Datastage from non-NLS to NLS (ie., reinstalled Datastage as NLS enabled). The source data is UTF-8, therefore, I enabled the NLS at the project level with UTF-8.
Problem:
After converting the field for the ODBC from varchar to nvarchar and char to nchar the Hash file is giving me all kinds of problems. I understand that it does not matter inside the datastage what format fields are and I only need to take care of field formats external to datastage. However, I keep getting log info messages whenever I add a particular column, the column is nchar with the field length of 2 and only values it contains are "NULL", "1", "N", "Y". Example of the message is as follows,
refSiebelS_ORG_EXT_X_HshS_ORG_EXT_XDW..xfmS_ORG_EXT_X.in: DSD.BCIGetNext call to SQLFetch returned informational message.
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
SQLSTATE=01004, DBMS.CODE=0
[DataStage][SQL Client]Data has been truncated
Appreciate any advice.
Srinivas
Data has been truncated
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: