0
478
Question Miguel Angel Gallardo Ruiz · Jun 13, 2018

Connect SQL to different schema

#Ensemble #Beginner #Business Operation #ODBC #SQL

Hello,

I want to know if there is any possible way to use the same query for different ODBC  schemas.

Thanks.

Discussion (4)0
Log in or sign up to continue

Comments

Miguel Angel Gallardo Ruiz  Jun 14, 2018 to Eduard Lebedyuk

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.

0
Robert Cemper · Jun 13, 2018

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

0