Preface
Scripting Overview
Tcl Scripting
SQL Scripting

Scripting Guide

9.8.0 HotFix 2

Back Next

Syntax of SQL Expressions

Data Replication inserts SQL expressions into SQL statements that run on the target database to replicate data. Ensure that the SQL expressions conform to the syntax of the target database.

For example, the standard SQL syntax for concatenation is to use the || operator. However, if you have a Microsoft SQL Server target database, use the + operator.

If you have a MySQL target database, use the CONCAT function.

Data Replication cannot process SQL expressions that use the :: construct for datatype casting. Instead, you must use explicit CAST or CONVERT requests.

Using SQL Expressions

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal