FYI: FP11 and error -925

bughunter

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

m0002a

What is documented? The APAR, or the fact that FP11 is now working as
designed?

Apr 14 '06 #2

Mark Yudkin

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