PermaLink Rollback action using DB2 LC LSX - pt. 6: updating an LCConnection property was the secret05/04/2005
LSX
After a month of working with various support organizations, including Lotus Support, I now have two ways to disable autocommit for DB2 LC LSX transactions.

Method 1:
'-- CommitFrequency property: specifies the number of modification actions between commits. 
'-- A value of zero causes a commit at disconnect; a value of one auto-commits after every action; 
'-- any other value commits after that many data modification actions.
Private Const COMMIT_FREQUENCY = 1 

'-- Used to set the LCConnection CommitFrequency property so that transactions are manually committed.
Private Const MANUAL_COMMIT = 0

'-- Set the DB2 Connector CommitFrequency property so that all transactions must be manually committed.
If ( con.LookupProperty ( COMMIT_FREQUENCY ) ) Then
	Call con.SetPropertyInt ( COMMIT_FREQUENCY, MANUAL_COMMIT )
End If
Method 2:
con.commitFrequency=0
I've used method 1, and it works! Who-hoo!
Comments :v
No comments.
Credits
NuTechs Powered by Domino
Search
Calendar
February 2012
Su
Mo
Tu
We
Th
Fr
Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Monthly Archive
Get Real, Detroit!
Real Detroit Weekly
SWARM
Service
With
A
Rapid
Motion


-- old Rally's Hamburgers credo
Lotus Domino ND6 RSS News Feed RSS Comments Feed Podcast Feed Geo URL netcraft RSS Validator Lotus Geek Chris. A. Brandlehner Open Notes Picture Database OpenNTF CoComment Integrated BlogSphere
By Category
The BlogRoll
About
Contact Me
Contact me, Michael Sobczak, using this e-mail address:

my first initial my last name at Yahoo dot com
Recent Entries
No Recent Blogs
Powered by
Blogsphere