while loading data from sybase to Oracle/Sql last byte is tr

vijaydev · Post by **vijaydev** » Thu May 31, 2007 3:31 am

Hi,

While loading data from Sybase to Oracle/Sql last byte is truncating for the fields having Korean characters what is the problem how to resolve this problem.

Help to resolve this problem...

ArndW · Post by **ArndW** » Thu May 31, 2007 3:53 am

There are a number of possibilities, but you will need to supply some more information.

1. You posted in the PX but specified a server job. Which type is it?
2. Are you using a NLS DataStage engine and databases?
3. If you read the Sybase source and write to a flat file, is the data correct?

(There are several more questions, but much will be answered if you post responses to the 3 listed above)

vijaydev · Post by **vijaydev** » Thu May 31, 2007 3:58 am

i wrongly posted in to this forum,
and
1. its an server job
2. i am using NLS enabled datastage
3. if i write it to a flat file it showing last byte as "?"

help me