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,
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
I'd leave it in. It's like chicken soup. It couldn't hurt.
WebFOCUS 8206, Unix, Windows
Hey Francis, I remember being told that it auto commits.
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
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.
Production: WebFOCUS 8.202M
QA: WebFOCUS 8.206.01
|Powered by Social Strata|