Hi, Is there a way to configure Torque to build (using generated om classes) queries involving more than one tablespace, like this:
SELECT POPULATION.CITIZEN.CODE, POPULATION.CITIZEN.NAME, UTIL.CITY.DESC FROM POPULATION.CITIZEN, UTIL.CITY WHERE POPULATION.CITIZEN.BORN_IN_CITY_CODE = UTIL.CITY.CODE In order to use both POPULATION and UTIL tablespaces, we use a generic jdbc url: jdbc:as400://<my_as400_address>;date format=eur without tablespace specification. This is a common requirement, in our application. Roberto Resoli __________________________________________________________________ Tiscali ADSL, l'offerta su misura per te a partire da 24,95 euro al mese! Scopri la tua adsl ideale con il TEST ON LINE http://point.tiscali.it/adsl/ -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
