Re: Transaction Managment DB2/400

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Ryan,

As a (I suppose) newcomer to DB2 for the IBM i, I would recommend you the
DB2 Database programming Manual, which you can find here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/dbp/rbafo.pdf

Also, there is a nice book about commiment control here:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzakj/rzakj.pdf

As in almost all the things related the IBM i, Google and the Infocenter are
your friends. The Infocenter link for V5R4 is:
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp


HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Mon, Apr 19, 2010 at 8:12 AM, Ryan Hunt <ryan.hunt@xxxxxxxxxxxxx> wrote:

> When I say transaction management, I mean:
>
> Start a unit of work-->perform work-->check for errors (if none
> found)-->commit work (else, rollback to start).
>
> I'm hoping the list can provide me with two things.
>
> 1) a good reference for reading the details of transaction management on
> DB2/400.  I started doing some research and found lots on isolation levels
> -
> but that seems more about isolation of reads (whether reads can be dirty,
> etc.) rather than enforcing change control.  (please note that I am
> primarily an MS SQL DBA/Developer so I may have gleaned something incorrect
> from my reading).
>
> 2) a quick primer to get me started, for instance, the real code to perform
> this:
>
> BEGIN TRANSACTION
>
> UPDATE table1
> set foo = x, bar = y
> WHERE col1 = Z;
>
> IF NO ERROR RETURNED THEN
> COMMIT;
> ELSE
> ROLLBACK;
> END IF;
>
> Thanks much. RH
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.