Where to input - Alter Session MULTI_STATEMENT_COUNT

[caz2]

I  am using tDBRow to query Snowflake but there are a couple of queries separated by semi colon. I know I need to set the MULTI_STATEMENT_COUNT to allow the multiple queries to run ok, but I don't know where to set it.

Is it in the snowflake connection tDBConnection and if so where? I tried it on Advanced Settings - Additional JDBC Parameters but it didn't like that statement.

[Anonymous · Accepted solution]

Hello @Carolyn Foster​ ,

You can use 2 tDBRow components to achieve the goal.

In the first tDBRow , setup the MULTI_STATEMENT_COUNT parameter like the below

"alter session set multi_statement_count=0;"

in the 2nd tDBRow, setup the multiple queries separated by semi like the below

 

[caz2]

Perfect - thank you