Different product databases in different languages with Oracle

[Eric.Lewis@swisscom.com]

Hi all!

We have a pretty intricate Oracle database which contains all the categories
and the products and everything in four languages.
The view alone for getting products into MiniVend is around 100 lines of
SQL...

What I need to do is depending on the locale tell MiniVend to get its
product data from another view (one for each language). As if I could write
in the catalog.cfg file
Database products viMiniVend_[loc]language[/loc] dbi:Oracle:etc.etc.
where "language" in the locale.asc would be
language   en   de   fr   it
(for English, German, French and Italian)

Of course, this code here doesn't work, but what code would work? Is it
necessary to have a view with all the languages and then make subqueries
like
SELECT * FROM viMiniVend_en WHERE language = 'en'
?

I'd be glad for any help you could give me! Thanks!

Best regards,
Eric Lewis

----------------------------------
   Swisscom AG      		mailto:eric.lewis@swisscom.com
   Informatik
   Eric Lewis, CIT-AE-742
   Postfach               		phone	+41-31/342 79 71
   CH-3050 Bern       		fax	+41-31/342 90 69
----------------------------------