Actian X 11.1 | Updating Data in X100 Tables

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: 11/09/2022