Configuration file	./conf/samples/sample_multiple_sql_cron.properties
Class name	com.ebd.hub.datawizard.util.MultipleSqlCron

Description

This class allows cascading multiple DefaultSqlCrons. The results of the individual DefaultSqlCrons are merged in the same order the DefaultSqlCrons are called. This order is defined in the configuration file, which contains the paths to the configuration files of the individual DefaultSqlCrons.

Example

sample_multiple_sql_cron.properties

#
#Sample config file for MultipleSQLCron
#
#Calls DefaultSQLCron several times with different config files and merges the results.
#Index starts at 0 and step size is 1.
#Single DefaultSQLCron does not write a dump to disk, even if defined in the individual config file. 
#
#Do not call other DefaultSQLCron when first call does not return any data (default)
continue_on_empty_result = false
#Calls DefaultSQLCron twice with the following config files:
config.0=./conf/sample_sql_cron1.properties
config.1=./conf/sample_sql_cron2.properties
#Dump result as a CSV file
save_as_csv=./dump_all.csv

Blanks in query result (MSSQL/Informix)

In MSSQL and Informix databases, the result values of SQL calls are trimmed of preceding and following spaces by default. The skipTrimResultValues parameter can be used in the database alias configuration file to change this behaviour.