Re: db2, php, AUTOCOMMIT off rollback not working

[Bdietz400 <bdietz400@xxxxxxxxx>]

Maybe just a wild guess, and not 100% it would make a difference.  Are you using "connect" or "pconnect"?

--
Bryan


On Mar 5, 2013, at 12:38 PM, "Sheldon Foster" <sheldon@xxxxxxxxxxx> wrote:

> I have the following code to test rollback transaction processing.  I get a
> count of records from a table, then delete all the records, then perform a
> roll back which should (supposedly) restore the records back to the table.
> I am able to confirm that the db2_autocommit_off is indeed getting set, but
> the rollback function never rolls back the prior deletion.  I can't seem to
> find much on the internet.  What am I missing?  (fyi, $telusr and $telpwd
> are being set correctly but I have not included the code here).
>
>
>
> For example, if I start out with 2 records, here is the result I get:
>
> Original record count: 2
>
> AUTOCOMMIT is off.
>
> Record count after delete: 0
>
> Record count after rollback: 0
>
>
>
> $db = "*LOCAL"; 
>
> $options = array ('i5_naming' => DB2_I5_NAMING_ON, 'autocommit' =>
> DB2_AUTOCOMMIT_OFF );
>
> if ($conn) {
>
>    $stmt = db2_exec($conn, "SELECT count(*) FROM teltrn");
>
>    $res = db2_fetch_array( $stmt );
>
>    echo "Original record count: " . $res[0] . "\n";
>
>
>
>    // Turn AUTOCOMMIT off
>
>    //db2_autocommit($conn, DB2_AUTOCOMMIT_OFF);
>
>      $ac = db2_autocommit($conn);
>
>      if ($ac == 0) {
>
>      print "AUTOCOMMIT is off.";
>
>      } else {
>
>      print "AUTOCOMMIT is on.";
>
>      }   
>
>    // Delete all rows from teltrn
>
>    db2_exec($conn, "DELETE FROM teltrn");
>
>
>
>    $stmt = db2_exec($conn, "SELECT count(*) FROM teltrn");
>
>    $res = db2_fetch_array( $stmt );
>
>    echo "Record count after delete: " . $res[0] . "\n";
>
>
>
>    // Roll back the DELETE statement
>
>    db2_rollback( $conn );
>
>
>
>    $stmt = db2_exec( $conn, "SELECT count(*) FROM teltrn" );
>
>    $res = db2_fetch_array( $stmt );
>
>    echo "Record count after rollback: " . $res[0] . "\n";
>
> }
>
> -- 
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/web400.