Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Guidelines for Entering Pre- and Post-Session SQL Commands

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.