AnsweredAssumed Answered

accessing a prod and training table from the same SQLcode

Question asked by acp on Jul 24, 2013
Latest reply on Jul 31, 2013 by acp
HI we started to explore using SQL for migrating a non mainframe SQL application to IDMS SQL database ...

With non-SQL IDMS the COBOL programs can switch using the subschema suffix and the DBNAME to point at prod and training databases.

We wish to do the same thing using SQL databases . The CREATE TABLE has a link to the physical area, and timestamps are checked between the catalog defn and the physical data.
which is fundamentally different from the non-SQL way of doing things..

Any elegant way to dynamically point to either the prod or training SQL database, using the same code..