@IF condition error
edited Aug 24, 2018 6:40PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓
Replicat is abending saying that mapping is in error.
Here is the error message:
ERROR OGG-01334 Error mapping data from DBO.GGFUNCTIONS to DBO.GGFUNCTIONS.state_val in function IF.
Can you tell me whats wrong with this statement?
MAP DBO.ggfunctions, TARGET DBO.ggfunctions
COLMAP (USEDEFAULTS,
state_val = @IF (state = "GA" OR state = "FL", "TRUE", "FALSE"));
1