My Oracle Support Banner

How to Program Conditional Clauses Using ODI Substitution Methods ? (Doc ID 424038.1)

Last updated on DECEMBER 18, 2019

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Goal

Depending on ODI Procedure or Knowledge Module Option values, I would like to conditionally execute specific blocks of code.

Is it possible using IF THEN ELSE commands?

The following pseudo-code is an example:

If OPT1 is checked (Yes) then
    Sql-Instruction 1
Else
    If OPT_2 = "foobar" then
        Sql-Instruction 2
    Else
        Sql-Instruction 3
    End if
End if

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.