How to execute multiple sql statements in one component .. Please let me know
I am using Snowflake DB
Do you want to use multiple sql statement in sql query field of tSnowFlakeInput component?
Have you already checked 'Manual query' check box and entered within double quotation marks in the Full SQL query string field?
Here exists a new feature jira issue about 'Integrate SnowFlake Components'
This issue has been fixed on V 6.4.1.
For tJDBCROW component, maybe you can add commit keyword in your query.
Got below error
Multiple SQL statements in a single API call are not supported; use one API call per statement instead.
creat a store procedure for those multiple sql's and use tJDBCSP comonent to execute that store procedure.