Unable merge through odbc driver

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

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

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file