Scripting Guide

9.8.0

Back Next

Adding Tcl Expressions

After you write a Tcl script based on the information in the Informatica Data Replication Scripting Guide
, enter the script for a source table in the Data Replication Console.

Before you begin, make sure that the Console is in Edit mode.

On the

Map Tables

tab, select the mapped source table row for which to define a Tcl expression.

Click the

Add or Show Table Expression

icon button above the source tables filter field, or right-click the table row and click

Add or Show Table Expression

The

Add/Show expressions

dialog box appears.

Click

New

Enter an expression name and click

An expression name can be no longer than 50 characters and can include only the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character.

In the

Language

field, select

TCL

Double-click the

Expression

field or click

Edit

The

Tcl Expression Editor

dialog box appears.

Enter a Tcl expression for processing the replicated data and click

The Tcl expression appears in the

Add/Show expressions

dialog box.

To edit an expression, double-click in the

Expression

field, or select the expression row and click

Edit

To rename an expression, double-click in the

Name

field. Then edit the expression name and press

Enter

To delete an expression that is not assigned to any virtual column, select the expression row and click

Delete

When done, click

Next, you can assign the Tcl expression to a virtual column.

Adding Tcl and SQL Expressions

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

Adding Tcl Expressions