|
Replies:
1
-
Pages:
1
-
Last Post:
Aug 28, 2012 11:22 AM
by: kmd
|
|
|
Posts:
5
Registered:
5/14/12
|
|
|
|
Submitting multiple statements in one BMF transaction semicolon not working
Posted:
Aug 24, 2012 7:29 AM
|
|
|
Hello, I want to submit one SQL statement and two DB2 store procedures using 1 BMF transaction. I heard the semicolon(;) would do it but not working for me. Can you help?
|
|
|
Posts:
133
Registered:
1/23/07
|
|
|
|
Re: Submitting multiple statements in one BMF transaction semicolon not working
Posted:
Aug 28, 2012 11:22 AM
in response to: querales
|
|
|
Just tested by running the following in a single Execute SQL transaction and it worked.
select * from A_Tiny; select * from A_Tiny; select * from A_Tiny;
I set BMF to output the transaction results to verify and I did get the correct rows returned of three (A_Tiny only contains one row). Can you verify by outputing your results to a file?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
