Disconnect keyword not showing any effect when used

[chiru_thota]

Hi All,

I have used

Disconnect;   to disconnect from vertica database ODBC connection and it did not work as I expected

Ex :

Connect ......ID/pwd;

load * ;slect * from table1;

Disconnect;

load * ;slect * from table2;

I thought it will give error as I did disconnect ODBC  after loading table1. But.But it has loaded data also from table 2 .

any ideas ?

thanks,

Chiru

[chiru_thota]

any inputs?

[Alejandro_Hernández]

what version are you using?

[chiru_thota]

[evan_kurowski]

Hello Naga,

I'd appreciate any insight into functionality behind the 'DISCONNECT' keyword as well.

I'm having a similar issue, but in my case a Teradata database is not closing connections opened by QlikView, even across multiple script executions.

Therefore if I run a script 10 times, and each time a single connection is established, after the 10th script execution I might have 10 simultaneous db connections open (which may trigger some account lock on the db side).  Either that or the script is failing to complete because it cannot release the connection.