DSXchange

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

nvarchar or nchar takes twice the space that varchar or char does to store one character, is it an issue with the length, what happens when you increase it?

"NULL" will not fit in Char(2)