lvector_create_table

Signature:

CREATE PROCEDURE lvector_create_table(table_name LVARCHAR, dimensions INTEGER);

Purpose: Creates or initializes a corresponding LanceDB/lvector table.

Example:

EXECUTE PROCEDURE lvector_create_table('docs_demo', 16);

Note: Informix source data and the LanceDB backing table must stay synchronized through explicit sync calls or triggers.

Note: The hard-coded table schema is as follows:

(
Id <64-bit integer>,
lvector <array[dimensions] of 32-bit floats>,
metadata <long variable-length UTF8>
)