Placement of Transaction Demarcation Calls
In coding application servers using Ingres, be aware of the following restrictions:
• If you choose to demarcate transactions in the application server, your transaction must not span multiple server groups. Transactions that span multiple server groups must be demarcated in the application client. (You can place transaction demarcation calls (tpbegin, tpcommit, tpabort) in application clients and application servers.)
• You may define and call AUTOTRAN services in your application, but those services may not make service calls to services in other server groups. That is, your transaction must not span multiple server groups.