GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

@Case combined with @if ?

edited Dec 17, 2015 10:14AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

I am trying to combine some conditions in OGG Transforms.

is it possible to combine goldengate transformation functions, for example embedding an @if inside a case statement? Or adding an extra condition for the case statement case 1  condition and extra  condition, case 2 condition, case 3 condition. Example shows case 1 has additional condition once initial condition has been met.

I cannot find any examples where @case is used with @if or where AND criteria is combined in one case, but not with others.  I have tried several combinations based on what I believe is correct syntax, but I get either colmap errors or transform errors, and the transform abends.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center