Using properties files to enable multiple database connections

Many applications, such as Crystal Reports, may require the primary database to dynamically connect to auxiliary databases without the need to issue a CONNECT statement for each instance of an auxiliary connection. In instances such as this, you may create a properties file which will initiate the auxiliary database connections once an application makes the initial connection to the primary database.