Database Administrator Guide > Database Administrator Guide > Updating Data in X100 Tables
Was this helpful?
Updating Data in X100 Tables
 
Methods for Updating Data in X100 Tables
Batch and Bulk Updates
Combining Tables
How to Avoid Propagation
MODIFY...TO COMBINE Statement--Merge and Update Data
Best Practices for Updates
Allowing Concurrent Inserts
Methods for Updating Data in X100 Tables
Data can be inserted, updated, and deleted using these methods:
• As a batch or bulk operation using SQL statements or the vwload command
• As a bulk operation using the MODIFY...TO COMBINE statement
• Using Actian DataFlow or other tools. Such tools generate the commands and SQL statements to load the data, so this method is not described separately.
Last modified date: 01/30/2023