[CLOSED] SQL Passthru INSERT statement - is a COMMIT necessary?
I have a fex with a SQL Passthru INSERT statement, do I really need a COMMIT statement, or because it's SQL Passthru with a FOCUS END statement, it happens automatically?
Thanks,This message has been edited. Last edited by: Francis Mariani,
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 18, 2018, 09:27 AM
BabakNYC
I'd leave it in. It's like chicken soup. It couldn't hurt.
WebFOCUS 8206, Unix, Windows
April 18, 2018, 09:51 AM
Fernando
Hey Francis, I remember being told that it auto commits.
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
April 18, 2018, 12:39 PM
RyanIPG13
Francis,
Are you using SQL? Looks like it based on your sig. If so, autocommit is the default behavior of the engine, FOCUS has nothing to do with it.
Oracle might be different and require a commit for a statement or group of statements.