Re: RE: Foreign Tab
Gnorei and Sebastian,
I have to tell you that the answer is : if your RDBMS is able to see it then "OneWorld is able to see it", even if it's out of the list of five type. I use this technique to read a sybase database from UTB, APPL or UBE !
Let me give you the basic step :
Let's say you want to access table "myforeigntable" with two field "client_number" and "client_name"
- make sure that you have the driver to contact your foreign table.
- In OneWorld create a table "F55TEST" with two field (we don't care about the name) for example TTAN8 and TTALPH. don't generate the table.
-Then in your database (SQL or Oracle) create in the OneWorld Database a view like this : "select client_number as TTAN8, client_name as TTALPH from myforeigntable"
-Next : Wow there is nothing else ! open utb and "READ" your foreign table from OneWorld. You can also create a OneWorld view over this "fake" OneWorld table.
Ok this answer was short but it is also because if you search on the list you will find a lot of post on this subject.
(The way I use will work for read only, no update)