Skip to main content

Unable merge through odbc driver

  • March 11, 2016
  • 2 replies
  • 13 views

rain_weezy

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?

2 replies

FiliN
Forum|alt.badge.img
  • Participating Frequently
  • March 11, 2016

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


rain_weezy
  • Author
  • New Participant
  • March 11, 2016

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.