Zoltan_Gyimesi
Legendary Poster
Hi List/Forum,
I have never used transaction processing up to now in batch applications. The documentations that I was able to find are very poor in this topic. Really hope, somebody already used this feature and can help me how to use it with success. Unfortunately I haven't time to experiences all of my open questions.
First, here is my scenario:
=====================
I want to create an interface UBE which gets input from a text file produced by a legacy system. The driver section of this UBE won't have Business View but will update records in two tables using Table I/Os in the event rules. My goal is that when I detect any problem (e.g. type conversion, invalid value, failing record update, etc.) during the running I want to Roll Back all update on the records that were done previously in this running.
Some of my several questions are:
=================================
0.) Does it work at all?
1.) Could somebody povide me with a good scenario?
2.) Could somebody povide me with or point to some good documentation or white-paper?
3.) Do I have to enable the Transaction Processing on the Report Properties or can I use simply the Begin, Commit and Rollback system functions without this setting?
4.) Does previous enabling start a transaction automatically for the report or do I have to do explicitily with Begin Transaction system functions?
5.) What kind of type parameter requiered for the Transaction ID in the transaction system functions (Numeric, Identifier, Integer, etc.)?
6.) What happens with the transaction when the UBE ends without issuing a Commit or Rollback call?
7.) Do I have to Open the tables (and later Close) with marked Include In Transaction check-box? If yes, then do I have to position the Open after Begin Transaction or is it all the same?
8.) What happens with the transaction when won't issue a Close for the table?
9.) Where to position the Close when it is required?
10.) Could be placed the Begin, Open, Update, Close, Commit and Rollback into different events of different sections? There is any required sequence for this calls?
11.) Can I handle more than one independent but simultaneous transactions?
12.) Can I handle more than one independent but NOT simultaneous transactions?
13.) Can I handle separate sub-transactions wich could be Rolled Back independently from the parent transaction?
14.) ... and several more ...
This topic is interested me generally but currently I want to deal with it on B7332 SP 11, NT server and workstations and SQL engine, so please, if you know any specility for this platform, let me know too.
Any help will highly appreciated!
Thanks in advance,
Zoltán
B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
I have never used transaction processing up to now in batch applications. The documentations that I was able to find are very poor in this topic. Really hope, somebody already used this feature and can help me how to use it with success. Unfortunately I haven't time to experiences all of my open questions.
First, here is my scenario:
=====================
I want to create an interface UBE which gets input from a text file produced by a legacy system. The driver section of this UBE won't have Business View but will update records in two tables using Table I/Os in the event rules. My goal is that when I detect any problem (e.g. type conversion, invalid value, failing record update, etc.) during the running I want to Roll Back all update on the records that were done previously in this running.
Some of my several questions are:
=================================
0.) Does it work at all?
1.) Could somebody povide me with a good scenario?
2.) Could somebody povide me with or point to some good documentation or white-paper?
3.) Do I have to enable the Transaction Processing on the Report Properties or can I use simply the Begin, Commit and Rollback system functions without this setting?
4.) Does previous enabling start a transaction automatically for the report or do I have to do explicitily with Begin Transaction system functions?
5.) What kind of type parameter requiered for the Transaction ID in the transaction system functions (Numeric, Identifier, Integer, etc.)?
6.) What happens with the transaction when the UBE ends without issuing a Commit or Rollback call?
7.) Do I have to Open the tables (and later Close) with marked Include In Transaction check-box? If yes, then do I have to position the Open after Begin Transaction or is it all the same?
8.) What happens with the transaction when won't issue a Close for the table?
9.) Where to position the Close when it is required?
10.) Could be placed the Begin, Open, Update, Close, Commit and Rollback into different events of different sections? There is any required sequence for this calls?
11.) Can I handle more than one independent but simultaneous transactions?
12.) Can I handle more than one independent but NOT simultaneous transactions?
13.) Can I handle separate sub-transactions wich could be Rolled Back independently from the parent transaction?
14.) ... and several more ...
This topic is interested me generally but currently I want to deal with it on B7332 SP 11, NT server and workstations and SQL engine, so please, if you know any specility for this platform, let me know too.
Any help will highly appreciated!
Thanks in advance,
Zoltán
B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)