Custom Table to capture unicode data for UBE Print

wcheehing

Active Member
We had just moved to E8.11 SP1 8.95G1 from Xe SP23 L2, currently 10 Environment with 6 Path Code.
One of the Environment needs to capture some Unicode (T. Chinese) data for some UBE to print (Customer's Info). We had not converted any Database to unicode due to Disk Space limitation.
Could we create a New Custom Table and Application for Users to enter the Unicode data into the table and create the UBE to read the Unicode Data and print?
Is there any special setting needed to create the Custom Table to hold the Unicode Data?



AS400 DB2, Windows 2003 Websphere 5.
 
You'll need to create new datasources (one for each environment) for the table even though the table can reside in PRODDTA. On the new datasource make sure the "unicode" flag is checked. Create OCM's to map the table to the new datasource in both the server map and system map. Generate the table into the new datasources, promote it and regenerate in each environment.

JDe will do the automatic conversion from unicode to non-unicode and back again.

Shouldn't take more than 1 hour to set up.


Colin
 
Hi,

You have to create a custom Data Source (such as
Business Data - China) and set its Unicode flag to Yes.
Then, you generate (from OMW) the custom table in the
custom Data Source you just created and, finally, you
add OCM mappings for that table.
 
Hi Colin & all,

Thanks for the information.
It is a very importance information for us.

CH
 
We tested on E8.12 Demo and found a problem.
Created a Custom Table and Appl. to write Unicode Data into the Custom Table.
From the Web Client, when we Entry a Unicode Data, it seem that the Unicode Data had been converted into another format and safed into the Table. After that the Data could not be read any more as orginal.
If we use the same application in Fat Client Mode to enter the Unicode Data, from the Entry Screen, we could not see the Actual Unicode Data, but once it is saved into the Table. We could see the Actual Unicode Data from the Web.
Is there any thing else needed to be set?
 

Attachments

  • 110871-Unicode Table.doc
    125.5 KB · Views: 68
Back
Top