0 Replies Latest reply: Feb 4, 2013 9:49 PM by Michael Fenton RSS

    Reuse same script to get data from multiple sources

      I am developing an App that is extracting data from a financial system. There are 3 different databases for 3 business entities. I want to reuse the same script for each data source as they have an identical schema.


      I am thinking of writing the common LOAD/SELECT statements in an include file and load it three times.  Something like the following:

      ODBC CONNECT32 To [<connection string 1>];
      ODBC CONNECT32 To [<connection string 2>];
      ODBC CONNECT32 To [<connection string 3>];



      Is this a sensible approach?  Is there any best practice for handling this situation?