Preface
Workflow Manager
Workflows and Worklets
Sessions
Session Configuration Object
Tasks
Sources
Targets
Connection Objects
Validation
Scheduling and Running Workflows
Sending Email
Workflow Monitor
Workflow Monitor Details
Session and Workflow Logs
Appendix A: Session Properties Reference
Appendix B: Workflow Properties Reference

Workflow Basics Guide

10.5
- 10.5.6
- 10.4.0

Back Next

SQL Query Override

You can alter or override the default query in the mapping by entering SQL override in the Properties settings in the Sources node. You can enter any SQL statement supported by the source database.

The Workflow Manager does not validate the SQL override. The following types of errors can cause data errors and session failure:

Fields with incompatible datatypes or unknown fields

Typing mistakes or other errors

Working with Relational Sources

Overriding the SQL Query

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

Workflow Basics Guide

Workflow Basics Guide

SQL Query Override

SQL Query Override