I try to send a synchronous SELECT message to the JDBC adapter. The database in use needs the DB schema in front of the tablename. So the select statement looks like this:
SELECT proddescr FROM dbschema.dbtable WHERE prodid="4711"
Translated into the XML-language of the JDBC adapter it looks like this:
because of the period ".". Can anybody tell me how to solve this problem?
How can I access DB tables for databases which need a DB schema in front of the tablename?
Thanks in advance.
Volker