Prema,
For our scenario ( shared the SQL queries in first post), the second query runs only based on first query getting passed. So the session for the both query needs to be same.
I am able to achieve same session only by selecting "Keep Connection Open". but the session is active even after the execution of second query.
--- My need is same session should be there for both queries and session should be closed after the execution of second query.