Workflow Basics Guide

Back Next

Guidelines for Entering Pre- and Post-Session SQL Commands

Use the following guidelines when creating the SQL statements:

Use any command that is valid for the database type. However, the Integration Service does not allow nested comments, even though the database might.

Use a semicolon (;) to separate multiple statements. The Integration Service issues a commit after each statement.

The Integration Service ignores semicolons within /* ...*/.

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

The Workflow Manager does not validate the SQL.

Watch

Comments

0 COMMENTS

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