DSXchange

Hi,
have you checked both both AS400 System and unix server are
the same transfer ASCII.

Thanks,
Malli

Hi All,
Can any body help me what is the advantage of audit logs in datastage.

Thanks,
Murali

can you replay the above issue why you wondering

where i delete the duplicate thread please

I am not tried using ISO8859-1 map for the ODBC stage that connects to SQL Server.
I used in the NLS map name used ODBC stage is NONE.

Thanks,
Malli

Hi,
NLS map name is Project default (ISO8859-1) used is used in db2 stage.
I dont know the data in db2 tables really encoded using this map.

so can you suggest me how can i slove this issue.

Thanks,
Malli

Hi, while loading data from db2 stage to ODBC is SQL Server i am getting the below warning DSD.BCIPut call to OCONV failed. Column: CountryName, NLS mapname: UTF8, Column data (after conversion): ?RGFD INMNGDS, Column data (in hex, before conversion) C65CDD4E442049534C414E4453 Here ? refers some inv...

Hi, the source string data Contains some invalid chracters with 2 rows those are not transfered to sql server so what i do to slove this issue. here source is db2 column datatype is VarChar2() and target is SQL server column data type is NvarChar2(). can you suggest me how to transfer the above rows...

Hi,
Transformer stage generating the error
iam not used any oconv function but data is from db2 to odbc some rows are not populated because of the some invalid characters data.
so can you see the below post for full details.
Thanks,
Malli

Hi,
Is there problem with target db datatype.
thanks,
Malli

Hi all, can any body help me about the below warning i used to load the data from db2 to SqlServer here the records are loded into successfully but warning is generated please find the below warning log can any body give suggestion Here i use the db2 column type is BigInt(19) and target sql server t...

NLS Setting in DB2 is NONE
NLS is in SQL Server is also NONE
i set the NLS Locale to US-ENGLISH

Thanks,
Malli

Hi ray,
i used in the column type is in sql server is NvarChar()

thanks,
Malli

Hi ray, I am using the data type is VarChar2() in sql server and db2 also Once again to find the below log : Column: ColumnName, NLS mapname: UTF8, Column data (after conversion): XXXX XXXX?XXX, Column data (in hex, before conversion) XXXXXXXXXXXXXXXXXXXXXXXXXX here XXXX XXXX?XXX is a Input String d...

Hi all, i load the data from db2 to sql server which shows the below warning Column: ColumnName, NLS mapname: UTF8, Column data (after conversion): xxxx xxx?xxx, Column data (in hex, before conversion) xxxxxxxxxxxxxxxxxxx can any body help me about the above warning how can i sloved?i am using ds se...