Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Importing and exporting data » Importing data

 

Import data with the MERGE statement

Use the MERGE statement to perform an update operation and update large amounts of table data. When you merge data, you can specify what actions to take when rows from the source data match or do not match the rows in the target data.

 Defining the merge behavior
 Branches in a merge operation
 Triggers defined on the target table
 Considerations for immediate materialized views
 Considerations for text indexes
 Example 1
 Example 2
 Using the RAISERROR action