abhilash1911 Posted May 10, 2011 Share Posted May 10, 2011 HiI 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??? Link to comment Share on other sites More sharing options...
abhilash1911 Posted May 11, 2011 Author Share Posted May 11, 2011 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? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now