IBM Support

How to achieve sequence of Insert operation

Technical Blog Post


Abstract

How to achieve sequence of Insert operation

Body

How to achieve sequence of Insert operation
i.e.Insert#2 should not be performed until Insert#1 completed.


When user have requirement to perform Insert operation in particular sequence to assure
business requirement of sequence of Insert statement.
e.g. If we have Insert in Table A further calling Insert in Table B and maintain the
sequence of activity where Insert A should finish first then Insert B and further on.

We can use Trigger with AFTER INSERT option.
https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0020229.html


If we have multiple Insert in Store procedure  The operation will be called sequentially
but they do not wait until one operation finish to call next one.

So best way to achieve sequence of insert would be through Trigger with After INSERT operation.

 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm13285993