DSXchange

I am getting garbage results while moving data (CCSID 838 - Thai) from DB2 I-series into Oracle. I tried both ODBC Connector and ODBC Enterprise with no luck. Even English data stored in fields with CCSID 838 coming incorrect. I moved different non-English data including double bytes before, but stu...

Found solution. Can't belive it. Resinstalled .Net framework 1.1 and it worked.

What other diagnostic information was generated? What's in the install log, for example? Thanks, yes, I looked, I have few install log files.All look good except asbnode_install.log have following at the end: (it's not helping me much) (Apr 16, 2011 8:40:13 AM), Install_asbnode, com.installshield.w...

I am getting :
error occurred configuring ASB node
while installing DS Client 8.0.1 on XP laptop, I did number of installations before, never got that error. I found on internet that installing MS Visual Studio will help, but it did not.

Thanks a lot

I am guessing this is a one time load. If yes then work with your dba to turn journaling off, do your load and then he can turn it on. If this operation will be required at all subsequent loads as well then you can ask your dba to create a jcl which can be invoked via your scheduling tool that turn...

Is it possible to move data into AS/400 table and do not have it under journal control? I need to move data as fast as I can with truncate first , so no need for journaling.

thanks a lot

I am loading data from DB2 AS/400 into Oracle using ODBC Enterprise Stage. On DB2 data in CCSID 937 and Oracle is in UTF32.
I can't find correct NSL map, tried quite few of them, no luck
Same goes for Koren, CCSID 933.

Any help? Thanks a lot

Boris

What character sets do those numbers refer to? ... Well, I finaly found a solution: In ODBC stage I and using Replace function to replcace "wrong" hex value and the converting all to graphic. Not very pleasant but works just fine: Cast(Replace( F.ABALPH, x'7B',x'69') as graphic (40) ccsid...

ArndW wrote:I don't understand your answer - character set 37 and 284? Are those codesets? What does "GET DATABASE CONFIGURATION" output? ...

On DB2 on AS/400 (systemi) you can defined field in a table to be certain character set, like 37 and 284

ArndW wrote:What is the character set of your source database, or source table? You need to tell DataStage this value on order for the DB2 read stage to work correctly ...

it is 37
I created another table and made it 284, no changes

both times comming as 35

Also, I am usning ODBC stage, sorry forgot to tell

ArndW wrote:Change your select to only get rows that have the character in that column. Then find out which position the character is in, i.e. 8, then output SEQ(Input.Column[8,1]) to get the ASCII value as the DataStage job sees it.

comming as 35, which is #

ArndW wrote:Perhaps the character is being translated incorrectly from DB2 to DataStage. Isolate the characte and use the SEQ() function to determine which ASCII value arrives in DataStage. ...

I am sorry, I am not sure how to do this

chulett wrote:What is the characterset of your target Oracle database? ...

NLS_CHARACTERSET=WE8MSWIN1252
NLS_NCHAR_CHARACTERSET=AL16UTF16

chulett wrote:What is the characterset of your target Oracle database? ...

I am not at the machine right now, but is I think it is UTF32

I am trying to ftp file form AS/400 using FTP Stage, having trouble with correct URL. Is the default IFS or Library?

thanks a lot