Connect SQL to different schema


class %SQL.Statement has a special property named %SchemaPath for this case.

property %SchemaPath as %String(MAXLEN="");

%SchemaPath provides a list of schema names for resolving unqualified names during statement preparation. By default, its value is null; to set its value, use a comma-delimited list of schema names


Yes, sure.

We are using a SQLGateway with an ODBC conection to acces an external  data base. We also have a bussines operation with a SQL.OutboundAdapter, here is where we want to execute the queries to the data base, in wich we would add the different schemas for each query's destination. So, we want to know if there is any way for the queries to acces different schemas without the need to add manually each one of them at the beginning.