Insert, update, and delete information

The explain text for the INSERT, UPDATE, or DELETE statement is self-explanatory.

Statement text for these SQL operations in db2expln output can be:

   Insert: Table Name = schema.name ID = ts,n
   Update: Table Name = schema.name ID = ts,n
   Delete: Table Name = schema.name ID = ts,n
   Insert: Hierarchy Table Name = schema.name ID = ts,n
   Update: Hierarchy Table Name = schema.name ID = ts,n
   Delete: Hierarchy Table Name = schema.name ID = ts,n
   Insert: Materialized Query Table = schema.name ID = ts,n
   Update: Materialized Query Table = schema.name ID = ts,n
   Delete: Materialized Query Table = schema.name ID = ts,n
   Insert: Global Temporary Table ID = ts, tn
   Update: Global Temporary Table ID = ts, tn
   Delete: Global Temporary Table ID = ts, tn