Rollback action using DB2 LC LSX - pt. 6: updating an LCConnection property was the secret05/04/2005'-- 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 IfMethod 2:
con.commitFrequency=0I've used method 1, and it works! Who-hoo!
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 | |||