I am new to DataStage can we need to load a excel file which has both ARABIC and ENGLISH text. Here my source id IBM DB2. If I want to display the Arabic content in my browser I need to store it in the UNICODE format in the Database. Can any one tell how to store the content in a excel file as UNICODE NLS . In DataStage the option has been provided only for Sequential files.Thanks in advance.Regards,Kris.

Questions by gkrishn01   answers by gkrishn01

Showing Answers 1 - 1 of 1 Answers

Benny Lim

  • Jul 21st, 2006
 

You may convert the Ascii Code using IBM DB2 tools. Or Setup linkage via ODBC connectivity thus loading from table to table.

Of course, DB2 can extract to plain Ascii Text.

For your info, Datastage loading from textfile is faster than table loading.

Good luck.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions