LCOPY

The LCOPY command is identical to the COPY command except that it loads data from a client system, rather than a cluster host.

Example

The following code loads the table TEST from the file C:\load.dat located on a system where the code is executed.

ODBCConnection<ODBCDriverConnect> test("VerticaSQL");

test.connect();

char *sql = "LCOPY test FROM 'C:\load.dat' DELIMITER '|';";

ODBCStatement stm(test.conn);

stm.execute(sql);