Preface
Data integration tasks
Mapping tasks
Data transfer tasks
Data loader tasks

Tasks

Back Next

Preprocessing and postprocessing SQL commands

You can run SQL commands before or after a task. For example, you can use SQL commands to drop indexes on the target before the task runs, and then recreate them when the task completes.

Data Integration

does not validate the SQL.

Use the following rules and guidelines when creating the SQL commands:

Use any command that is valid for the database type. However,

Data Integration

does not allow nested comments, even if the database allows them.

Use a semicolon (;) to separate multiple statements.

Data Integration

issues a commit after each statement.

Data Integration

ignores semicolons within comments. If you need to use a semicolon outside of comments, you can escape it with a backslash (\).

Preprocessing and postprocessing commands

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

Tasks

Tasks

Preprocessing and postprocessing SQL commands

Preprocessing and postprocessing SQL commands