How to pass a Multiline SQL query as parameter
Posted: Thu Jul 20, 2017 12:23 am
Hi Team,
I have a generic ETL job which takes the SQL query given by user and loads a specific target table. Currently I have created a parameter to take the SQL query from user, however its not taking multi line queries. The complete query need to be given in one line.
Is there any other ways I can use to achieve this.
Note : I am using Enterprise SQL stage as Source stage and ODBC stage as Target stage.
Regards
Sree
I have a generic ETL job which takes the SQL query given by user and loads a specific target table. Currently I have created a parameter to take the SQL query from user, however its not taking multi line queries. The complete query need to be given in one line.
Is there any other ways I can use to achieve this.
Note : I am using Enterprise SQL stage as Source stage and ODBC stage as Target stage.
Regards
Sree