abhilash1911

Hi, I figured out an alternative to the above problem, i have created all the sql's from the sql list in the database repository. However i need to run a set of these sql's, and these set of sql's needs to be dynamic, ie it depends on the data retrieved while running the job. Any solution or suggestion on how to implement this?

Hi I am designing a job where i will be retrieving a list of sql file names from a database based on some conditions. The original sql's are present in my local machine in which i have installed JasperETL 3.2. I need to read this list which is in a CSV file created in the local machine, and read these files and create another single sql into which the content of the sql's from the list will be copied. Is there a way to do this? so far i am able to get the list of sql files, but i am not sure how to copy their content into a single sql file in the same machine. And execute this single sql in another database???