Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Passthru INSERT statement - is a COMMIT necessary?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SQL Passthru INSERT statement - is a COMMIT necessary?
 Login/Join
 
Expert
posted
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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
I'd leave it in. It's like chicken soup. It couldn't hurt.


WebFOCUS 8206, Unix, Windows
 
Posts: 1852 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Guru
posted Hide Post
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
 
Posts: 277 | Registered: October 10, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
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.


Production: WebFOCUS 8.202M
QA: WebFOCUS 8.206.01
Windows/SQL
 
Posts: 37 | Registered: May 24, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SQL Passthru INSERT statement - is a COMMIT necessary?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.