how to disable auto commit when run winsql command-line

Asked Aug 04 '16 at 13:22

Active Nov 16 '17 at 11:04

Viewed 371 times

I have this code in c#:

 string parameters = "-cDriver={IBM DB2 ODBC DRIVER};Database=" + txtDb.Text + ";hostname=" + txtIp.Text + ";port=" + txtPort.Text + ";protocol=TCPIP;uid=" + txtUid.Text + ";pwd=" + txtPws.Text + "";

 Process myProcess = new Process();
 myProcess.StartInfo.UseShellExecute = false;
 myProcess.StartInfo.FileName = "\"C:\\Program Files (x86)\\WinSQL\\Winsql.exe\" \"" + parameters + "\"";
 myProcess.StartInfo.CreateNoWindow = true;
 myProcess.Start();

When the WinSql is open it is with autocommit enabled, however i need to disable.

edited Nov 16 '17 at 11:04

asked Aug 04 '16 at 13:22

Roberto Pegoraro

1,313
2
16
31

Did you try passing the corresponding property in the connect string? – mustaccio Aug 04 '16 at 14:32
I did not find the property for that, so my question. – Roberto Pegoraro Aug 05 '16 at 20:25
[AutoCommit=0](http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0008772.html) – mustaccio Aug 05 '16 at 21:00
1

AutoCommit=0 Dont work – Roberto Pegoraro Aug 12 '16 at 11:48

how to disable auto commit when run winsql command-line

0 Answers0