Skip to main content

How do I stream data using ODBC?

  • February 11, 2013
  • 1 reply
  • 6 views

KantiM
Am trying to get my data into Vertica database and am unclear on steps to do so.

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • February 11, 2013
You can use batch inserts from ODBC to stream data, as with COPY statements.Or, if your data is already in a file on the client, use COPY LOCAL. COPY and COPY LOCAL are described in the HP Vertica documentation, in the SQL Reference Manual. Also, see the HP Vertica Programmer's Guide section: Programming ODBC Client Applications > Loading Data through ODBC