lvector_bulk_sync
Signature:
CREATE PROCEDURE lvector_bulk_sync(ifx_table LVARCHAR, lvector_table LVARCHAR, id_column LVARCHAR, lvector_column LVARCHAR);
Purpose: Bulk syncs existing Informix table data into the lvector/LanceDB backing table.
Example:
EXECUTE PROCEDURE lvector_bulk_sync('src_docs', 'docs_demo', 'id', 'embedding');Note: Use after initial load or after recreating a backing LanceDB table.
Column names should be safe SQL identifiers.