I have searched the net, read a book and I still can't seem to get the syntax correct for the following problem.
I have been sent 2 columns of data that contain 45,000 rows within an Excel spreadsheet to update on an informix database, although not every PK record needs the usa_flg updated. The columns to be updated to include the following via Query Tool ODBC:
fir_num (PK - int), usa_flg (char) - check out the screenshot to see.
I've tried all sorts of INSERT and UPDATE queries to no avail. I think it's the volume of records that's stopping me.
Does anyone have any experience in updating thousands of records based on the PK?
The closest I've been able to produce is:
WHERE fir_num, usa_flg
SET VALUES (1, 2342342