We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Unable merge through odbc driver — Vertica Forum

Unable merge through odbc driver

rain_weezyrain_weezy
in General Discussion

Hi everyone,

 

I am writing C/C++ program using odbc driver and have a problem with following:

I load data into source table via COPY and it is OK, but when I trying to perform MERGE query, odbc driver writes into log

[ODBC][15187][1457692415.232803][SQLExecDirect.c][515]
        Exit:[SQL_NO_DATA]

Should it work or MERGE query not supported with odbc client? Or what solution would be better for it?

Comments

  • FiliNFiliN

    Are you sure that the point is a driver not query itself?

  • rain_weezyrain_weezy

    Yes, because those queries I succesful tested with vsql, but they don't work with odbc. I tried perform them in isql also and get NO_DATA.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...