DSXchange

I finally figured out the problem. All the columns containing Japanese characters were listed as "VARCHAR". The job started to process the characters as soon as I changed the definition of the columns to "NVARCHAR"

Ray, Data in the source is encoded in UTF-8 format. I have changed the NLS at the project level to UTF8. Also, added an environment variable NLS_LANG with " AMERICAN_AMERICA.AL32UTF8 " as the value. I'm still not able to process the Japanese characters. Can you please point me to the right...

Ray,

We do want to process the Japanese characters. Can you please let me know the correct way to process these characters while populating data in the destination table

Thanks
Yamini

UTF8 is set as the default NLS at the project level. Also, can you please tell me how I can remove the ustring?

Thanks
Yamini

Friends, Currently I'm working on designing a job that transfers data between 2 Oracle databases. Both the databases are set to UTF8 NLS character set. I could clearly see the Japanese characters ( す下る )when I login to the source db. The problem is that the Japanese characters are being replaced by ...

Hello there, I'm trying to install DataStage 8.x on a Windows XP machine but getting the following error ECommonMsg88010: The user smithm exists on the system with a different or expired password, the user account is disabled, or the user does not have permission to access this machine from the netw...

Thanks Ray.
Can you please explain how I can get the max value by using @OUTROWNUM

Thanks
Yamini

Friends, Currently I'm working on a task which requires me to update the log table with the number of records processed each time the job is executed. The design of the job is quite simple. It extracts data from 2 tables in the source db and writes to 2 tables in the destination db STBL1==>Transform...

Try storing rejected records to a file and check what's causing the unique constraint violation

Ray, I was able to design the jobs to store and pass the variables using UserStatus based on the information you provided in a different post. How can I use the end_date in Job2 to update the log table? Do I have to convert the date into DataStage internal format before updating the field in the dat...

Re-posting as I wasn't sure if you guys got my response There are 3 jobs in the Sequence which are executed sequentially. end_date is the system date when the first job started. We would like to persist the end_date throughout the 3 jobs. In the next cycle we will use the end_date as the start_date...

There are 3 jobs in the Sequence which are executed sequentially. end_date is the system date when the first job started. We would like to persist the end_date throughout the 3 jobs. In the next cycle we will use the end_date as the start_date for the jobs and so on. The jobs are executed 4-5 times ...

Friends, Is there a way to pass parameter to Oconv function? My current assignment requires me to do the following 1) read the start_date and end_date from log table and pass them as variables to the next job 2) Select data from source based on the values provided by above step (1) 3) Update the log...

Ray/Craig,

Thanks a lot for your help

-Yamini

Craig,

On further analysis I found that we can't pass more than 1 argument to the routine DSSetUserStatus.

Can you please explain how I can put more than 1 value in $USERSTATUS (in a delimited string)

Thanks
Yamini