DSXchange

Hi, I have job where i am using join stage and doing left outer join. Whenever i run the job the output varies. Means for each run the output count varies. earlier I was not sorting the data before joining. I tried to use hash partition and sort the data in transformer but this is also not working p...

Hi, I am using ODBC Enterprise stage to read the data from DB2 table and the datatype of the column is VARGRAPHIC and length in the table is 1024. Data is loading properly into the target table but i am getting following two warnings. When i import metadata the dataype in Datastage is NVARCHAR and u...

Hi,

I am able to load the data into DB2 table using ODBC Enterprise stage. and able to view the data in DB2 table as it looks in source. Can any body let me know why its so. Why cannot i see the correct data when i use DB2 Stage

Hi,

I am loading DB2 table using ODBC Enterprise stage. I am getting following error.

Internal Error: (0): odbc_upsert_subop.C: 1387
Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH

DB2 Stage is DB2_UDB_Enterprise_15

Database code set = UTF-8

Do i need to change any setting in DS to view the data correctly

Hi

The feed file which i am getting is UTF-8 only. when i open the file and do save as and check the encoding it is showing UTF 8.

Hi,

This got resolved, i was substr function in the source SQL query. I came to know that we cannot use any functions for different language in SQL statement if it the job is used as UTF

Please find the data which i am loading for the above warning. 2009-08-12 8.25 正在等客户的两个公司的材料。8.24 Cao Yan已在系统中void掉发票了。8.20 客户说已退回发票，正在等OO关于合同转让的邮件。8.19 OO要给客户做合同转让，估计要下周才能有所进展，不� Data is getting loaded into seq file. But i getting above warning. and datatype in table VARGRAPHIC and Datastage i am r...

That is set to unicode to extended column in stage

Database is set up to UTF-8. and in other two jobs i am loading the data into DB2 table as well as reading the data.

Db2Api_PRELOAD_PLD_COLLECTIONS_TGT,0: Invalid character(s) ([xE6]) found converting string (code point(s): 2009-08-12 8.25 [xE6][xAD][xA3][xE5][x9C][xA8][xE7][xAD][x89][xE5][xAE][xA2][xE6][x88][xB7][xE7][x9A][x84][xE4][xB8][xA4][xE4][xB8][xAA][xE5][x85][xAC][xE5][x8F][xB8][xE7][x9A][x84][xE6][x9D][x...

APT_CombinedOperatorController,0: Invalid character(s) ([xE6]) found converting string (code point(s): 2009-08-12 8.25 [xE6][xAD][xA3][xE5][x9C][xA8][xE7][xAD][x89][xE5][xAE][xA2][xE6][x88][xB7][xE7][x9A][x84][xE4][xB8][xA4][xE4][xB8][xAA][xE5][x85][xAC][xE5][x8F][xB8][xE7][x9A][x84][xE6][x9D][x90][...

edOperatorController,0: Invalid character(s) ([xE6]) found converting string (code point(s): 2009-08-12 8.25 [xE6][xAD][xA3][xE5][x9C][xA8][xE7][xAD][x89][xE5][xAE][xA2][xE6][x88][xB7][xE7][x9A][x84][xE4][xB8][xA4][xE4][xB8][xAA][xE5][x85][xAC][xE5][x8F][xB8][xE7][x9A][x84][xE6][x9D][x90][xE6][x96][...

Hi, I am receiving chinese characters in the feed file. and i am loading this file in DB2 table. In DS i am using UTF 8 in Job properties in NLS tab as well as in stages. Data is getting loaded into the table 1. Next job is loading data from table 1 into Dataset. then from Dataset to Table2, This is...

Hi,

I am not able to get your answer what u explained. can you please ellobarate please