i'm writing two 'insert' statements, this should work as a single transaction...
is there any command in DB2 to start the transaction (like Begin Tran)...
Ex.
Expand|Select|Wrap|Line Numbers
- Insert into SchemaName.Table1 (field1, field2)
- Values ('test1', 'test12')
- Insert into SchemaName.Table2 (field1, field2)
- Values ('test22', 'test222')
- Commit;
thanks in Adv.