I having trouble specifying schema qualifier for tables.  I login to
database using a user "dbuser", but my tables lie under a different schema

say XYZ schema.

 

Now I want to query XYZ.TABLE1.  But torque seems to generate sql something
like,

 

SELECT COL1, COL2, COL3 FROM dbuser.TABLE1   instead of

 

SELECT COL1, COL2, COL3 FROM XYZ.TABLE1

 

 

I would appreciate any pointer on solving this problem.

 

Thanks

Paddy

 

 

Reply via email to