Database Administrator Guide > Database Administrator Guide > Updating Data in X100 Tables > MODIFY...TO COMBINE Statement--Merge and Update Data > Propagate In-memory Updates to Disk
Was this helpful?
Propagate In-memory Updates to Disk
During batch operations X100 automatically propagates the changes buffered in memory to the disk-resident table.
To do this manually, use the MODIFY...TO COMBINE statement. Doing so frees this memory, which is shown as memory.update_allocated in the vwinfo output.
Use the following SQL statement:
MODIFY table_name TO COMBINE
Last modified date: 01/30/2023