By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

FYI: FP11 and error -925

P: n/a
After install FP11 I found difference with previous versions. When I
call sp with commit inside from as400 on UDB now I got exception -925

o When issued from a stored procedure, SQL COMMIT is also not
allowed if the calling program is executing in a distributed
unit of work or Distributed Transaction Processing
environment.

On FP10 this call works without errors.

Yes, it's documented as I see now... :-)

AP

Apr 14 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
What is documented? The APAR, or the fact that FP11 is now working as
designed?

Apr 14 '06 #2

P: n/a
I got bitten by something similar. CONNECT(2) now forces
SYNCPOINT(TWOPHASE) - in fact the SYNCPOINT option is now ignored.

"bughunter@ru" <a.********@gmail.com> wrote in message
news:11********************@i39g2000cwa.googlegrou ps.com...
After install FP11 I found difference with previous versions. When I
call sp with commit inside from as400 on UDB now I got exception -925

o When issued from a stored procedure, SQL COMMIT is also not
allowed if the calling program is executing in a distributed
unit of work or Distributed Transaction Processing
environment.

On FP10 this call works without errors.

Yes, it's documented as I see now... :-)

AP

Apr 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.