Preface
Using the Designer
Working with Sources
Working with Flat Files
Working with Targets
Mappings
Mapplets
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Viewing Data Lineage
Comparing Objects
Managing Business Components
- Managing Business Components Overview
  - Business Component Locking
  - Creating Links to Business Component Documentation
- Managing Business Components and Directories
Creating Cubes and Dimensions
Using the Mapping Wizards
Appendix A: Datatype Reference
Appendix B: Configure the Web Browser
- Configure the Web Browser

Designer Guide

10.5.6
- 10.5.7
- 10.5
- 10.4.1
- 10.4.0

Back Next

Overriding the WHERE Clause

You can override the WHERE clause to include non-key columns. For example, you might want to update records for employees named Mike Smith only. To do this, you edit the WHERE clause as follows:

UPDATE T_SALES SET DATE_SHIPPED = :TU.DATE_SHIPPED,

TOTAL_SALES = :TU.TOTAL_SALES WHERE :TU.EMP_NAME = EMP_NAME and 

EMP_NAME = 'MIKE SMITH'

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Overriding the WHERE Clause

Overriding the WHERE Clause