dewizard:howto:updating_deleting_records

Updating/Deleting Records

In order to Update or Delete records you must specify update key.

Add New and Update Old Records

Select count(*) 
from [DEMO].[dbo].[orders] 
where CustomerId=? And OrderNo=?

If any records found Data Exchange Wizard will update them by executing

Update [DEMO].[dbo].[orders]
set orderdate=?,
 amount=?
where customerid=? And OrderNo=?

If no records found Data Exchange Wizard will add new records

Updating Records

Update [DEMO].[dbo].[orders]
set OrderDate=?,
 Amount=?
where CustomerId=? And OrderNo=?

Deleting Records

Delete from [DEMO].[dbo].[orders]
Where CustomerId=? And OrderNo=?

Note: Add New and Update Old Records is not supported for SQL Server Connection use ODBC connection instead

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • dewizard/howto/updating_deleting_records.txt
  • Last modified: 17/09/2018 09:44
  • by admin