<div dir="ltr"><div>We think we have a solution...<br><br><br></div><div>The intention was to select which instance of a DB to open via variable (PH would select which ODBC connector to use based on OPEN $VARIABLE).. That was the part we could get working.. (think of it as having 4 instances of an Oracle database DEV,TEST, UAT and PROD and you don't want to recompile the programs just point it and go).. However we can't get it to work with the ODBC connector. The part we couldn't get working was that DB2 references things as SCHEMA.TABLE but the SCHEMA is supposed to able to defaulted in the ODBC connection..<br>
<br></div><div><div>The OWNER keyword in the dictionary does work but it has to be hard-coded in the dictionary.. as opposed to the OPEN which could be changed via a variable.<br></div><div><br></div>So we will create one dictionary per account and set the owner appropriately on an application basis. <br>
<br></div><div>So instead of dynamically selecting the ODBC connection with a variable we will use the variable to select the dictionary.. I probably won't need as many ODBC connectors but I will need 50 dictionaries..<br>
<br></div><div><div><br>-- <br>Thanks<br><br>Brian Stephens
</div></div></div>