Preface
Scripting Overview
Tcl Scripting
SQL Scripting

Scripting Guide

9.7.0 HotFix 1

Back Next

String Substitution Example

This example shows how to use the SQL Script Engine to substitute a string value.

The following figure shows how the source table columns and virtual column map to the target table columns:

The replace_path SQL expression gets the REDO value of the PATH column in a source table and replaces the string '/home/user_1' in the REDO value with '/home/user_2':

REPLACE(:NEW.PATH, '/home/user_1', '/home/user_2')

This SQL expression is identical for Oracle and SQL Server targets.

SQL Script Examples

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Scripting Guide

Scripting Guide

String Substitution Example

String Substitution Example