DB2 Again .. Solution Maybe...

[Brian Stephens]

We think we have a solution...


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..

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.

So we will create one dictionary per account and set the owner
appropriately on an application  basis.

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..


-- 
Thanks

Brian Stephens
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20130712/6a4ed78b/attachment.htm>