Managing Configuration Items › Manage Staged Transactions › Populating the TWA › How to Use SQL to Update Data into the TWA › Inssert New Records in the TWA

Inssert New Records in the TWA

You can insert a new record into the ci_twa_ci and ci_twa_relation tables from outside of CA SDM.

To insert records into the ci_twa_ci and ci_twa_relation tables, specify 0 in the ID column as:

insert into ci_twa_ci values(id, name) values(0,'test-ci');
insert into ci_twa_relation values(id, type) values(0,'test-relation-type');

Caution: If multi-tenancy is enabled, provide tenant, tgt_tenant, provider_tenant or dependent_tenant attributes as appropriate. If you create TWA transactions without tenant specified, the Public tenant is assumed.